PAY GB EDI WNU (3) Process Output

➜ Back to Library

Description
Categories: BI Publisher, Human Resources Application: Payroll Source: GB EDI WNU (3) Process Output Short Name: PYGBWNUETO DB package: PAY_GB_WNU_EDI_BIP more less

Copy

			select nvl(hoi.org_information11,' ') SENDER_ID,
				   'INLAND REVENUE' RECEIVER_ID,
				   decode(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') TEST_INDICATOR,
				   ' ' URGENT_MARKER, -- as a space is required in this place
				   fnd_number.number_to_canonical(pact.request_id) REQUEST_ID,
				   '18' FORM_TYPE,
				   'WNU' FORM_TYPE_MEANING,
				   nvl(substr(hoi.org_information1,1,3),' ') TAX_DIST_NO,
				   nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') TAX_DIST_REF,
				   nvl(upper(hoi.org_information2),' ') TAX_DISTRICT, 
				   nvl(upper(hoi.org_information4),' ') EMPLOYERS_ADDRESS_LINE,
				   nvl(upper(hoi.org_information3),' ') EMPLOYERS_NAME,
				   to_char(sysdate, 'YYYYMMDDHH24MISS') SYSTEM_DATE,
				   PAY_GB_WNU_EDI_BIP.cp_address_1 E_ADDRESS1,
				   PAY_GB_WNU_EDI_BIP.cp_address_2 E_ADDRESS2,
				   PAY_GB_WNU_EDI_BIP.cp_address_3 E_ADDRESS3,
				   PAY_GB_WNU_EDI_BIP.cp_address_4 E_ADDRESS4,
				   PAY_GB_WNU_EDI_BIP.cp_address_5 E_ADDRESS5
			from   pay_payroll_actions pact,
				   hr_organization_information hoi
			where  pact.payroll_action_id = :P_PAYROLL_ACTION_ID
			and    pact.business_group_id = hoi.organization_id
			and    hoi.org_information_context = 'Tax Details References'
			and    nvl(hoi.org_information10,'UK') = 'UK'
			and    substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,
				   instr(pact.legislative_parameters||' ',' ', instr(pact.legislative_parameters,'TAX_REF=')+8) -
				   instr(pact.legislative_parameters, 'TAX_REF=') - 8) = hoi.org_information1

Parameter Name

SQL text

Validation

DebugFlag

Payroll Action ID

Download

Related Blitz Reports
PAY Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins) PAY RTI - Year End P60 Report Process PAY Business Payrolls Survey PAY RTI - Year End P60 Report Process (Multi Threaded) PAY Inland Revenue Remittance Certificate PAY P45(3) & P46 Exception PAY Summary of Tax Certificates PAY A8B Summary PAY GB - DEA Payment Schedule Output

Blitz Report In Action