[Home] [Help]
71: 'TAX_DISTRICT=P', upper(nvl(substr(hoi.org_information2 ,1,40),' ')),
72: 'EMPLOYERS_ADDRESS_LINE=P',
73: upper(nvl(substr(hoi.org_information4,1,60),' ')),
74: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' '))
75: FROM pay_payroll_actions pact,
76: hr_organization_information hoi
77: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
78: ('TRANSFER_PAYROLL_ACTION_ID')
79: AND hoi.org_information_context = 'Tax Details References'
128: substr(fai.VALUE,1,35))),' '))
129: FROM pay_assignment_actions act_edi,
130: pay_action_interlocks pai,
131: pay_assignment_actions act,
132: pay_payroll_actions pact,
133: ff_archive_items fai,
134: ff_user_entities fue
135: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
136: ('TRANSFER_PAYROLL_ACTION_ID')
164: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' ')),
165: 'TEST_ID=P' , nvl(pay_gb_eoy_archive.get_parameter
166: (legislative_parameters,
167: 'TEST_ID'),' ') /*added for P45PT1*/
168: FROM pay_payroll_actions pact,
169: hr_organization_information hoi
170: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
171: ('TRANSFER_PAYROLL_ACTION_ID')
172: AND hoi.org_information_context = 'Tax Details References'
225: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
226: FROM pay_assignment_actions act_edi,
227: pay_action_interlocks pai,
228: pay_assignment_actions act,
229: pay_payroll_actions pact,
230: ff_archive_items fai,
231: ff_user_entities fue
232: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
233: ('TRANSFER_PAYROLL_ACTION_ID')