[Home] [Help]
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'
80: AND substr(pact.legislative_parameters,
81: instr(pact.legislative_parameters,'TAX_REF=') + 8,
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')
137: AND act_edi.assignment_action_id = pai.locking_action_id
138: AND act.assignment_action_id = pai.locked_action_id
139: AND pact.payroll_action_id = act.payroll_action_id
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'
173: AND substr(pact.legislative_parameters,
174: instr(pact.legislative_parameters,'TAX_REF=') + 8,
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')
234: AND act_edi.assignment_action_id = pai.locking_action_id
235: AND act.assignment_action_id = pai.locked_action_id
236: AND pact.payroll_action_id = act.payroll_action_id