PAY GB EDI WNU (3) Process Output
Description
Categories: BI Publisher
Columns: Sender Id, Receiver Id, Test Indicator, Urgent Marker, Request Id, Form Type, Form Type Meaning, Tax Dist No, Tax Dist Ref, Tax District ...
Columns: Sender Id, Receiver Id, Test Indicator, Urgent Marker, Request Id, Form Type, Form Type Meaning, Tax Dist No, Tax Dist Ref, Tax District ...
Application: Payroll
Source: GB EDI WNU (3) Process Output
Short Name: PYGBWNUETO
DB package: PAY_GB_WNU_EDI_BIP
Source: GB EDI WNU (3) Process Output
Short Name: PYGBWNUETO
DB package: PAY_GB_WNU_EDI_BIP
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 | |
---|---|---|---|
Payroll Action ID |
|
||
DebugFlag |
|