[Home] [Help]
51: --
52: CURSOR csr_wnu_header IS
53: SELECT 'TRANSFER_SENDER_ID=P', nvl(upper(hoi.org_information11),' '),
54: 'TRANSFER_RECEIVER_ID=P', 'INLAND REVENUE',
55: 'TEST_INDICATOR=P', upper(decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1')),
56: 'URGENT_MARKER=P', upper(decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1')),
57: 'ICR=P', upper(fnd_number.number_to_canonical(pact.request_id)),
58: 'FORM_TYPE=P', '5',
59: 'FORM_TYPE_MEANING=P', 'WNU',
52: CURSOR csr_wnu_header IS
53: SELECT 'TRANSFER_SENDER_ID=P', nvl(upper(hoi.org_information11),' '),
54: 'TRANSFER_RECEIVER_ID=P', 'INLAND REVENUE',
55: 'TEST_INDICATOR=P', upper(decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1')),
56: 'URGENT_MARKER=P', upper(decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1')),
57: 'ICR=P', upper(fnd_number.number_to_canonical(pact.request_id)),
58: 'FORM_TYPE=P', '5',
59: 'FORM_TYPE_MEANING=P', 'WNU',
60: 'FORMAT_TYPE=P', 'WNU',
62: 'TAX_DIST_NO=P', upper(substr(hoi.org_information1,1,3)),
63: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/') ,1,10))
64: FROM pay_payroll_actions pact,
65: hr_organization_information hoi
66: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
67: AND hoi.org_information_context = 'Tax Details References'
68: AND NVL(hoi.org_information10,'UK') = 'UK'
69: AND hoi.organization_id = pact.business_group_id
70: AND substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,
85: 'TITLE=P', nvl(upper(pai_emp.action_information14),' ')
86: from pay_assignment_actions paa,
87: pay_action_information pai_emp,
88: pay_action_information pai_wnu
89: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
90: and paa.assignment_action_id = pai_emp.action_context_id
91: and pai_emp.action_information_category = 'GB EMPLOYEE DETAILS'
92: and pai_emp.action_context_type = 'AAP'
93: and paa.assignment_action_id = pai_wnu.action_context_id(+)
107: 'TITLE=P', nvl(upper(pai_emp.action_information14),' ')
108: from pay_assignment_actions paa,
109: pay_action_information pai_emp,
110: pay_action_information pai_wnu
111: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
112: and paa.assignment_action_id = pai_emp.action_context_id
113: and pai_emp.action_information_category = 'GB EMPLOYEE DETAILS'
114: and pai_emp.action_context_type = 'AAP'
115: and paa.assignment_action_id = pai_wnu.action_context_id(+)