APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_PAYROLL_ACTIONS

Line 138: -- pay_payroll_actions pact,

134: -- pay_action_interlocks pail,
135: -- pay_assignment_actions act,
136: ----------------------------------------------------------
137: -- Bug 4059844 - SQL Repository Perf
138: -- pay_payroll_actions pact,
139: pay_action_information pai
140: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
141: ('TRANSFER_PAYROLL_ACTION_ID')
142: AND act_edi.assignment_action_id = pai.action_context_id

Line 176: FROM pay_payroll_actions pact,

172: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD')
173: -to_date('06-04-'|| to_char(to_date(substr(pact.legislative_parameters,
174: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
175: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
176: FROM pay_payroll_actions pact,
177: hr_organization_information hoi
178: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
179: ('TRANSFER_PAYROLL_ACTION_ID')
180: AND hoi.org_information_context = 'Tax Details References'

Line 256: -- pay_payroll_actions pact,

252: -- pay_action_interlocks pail,
253: -- pay_assignment_actions act,
254: ----------------------------------------------------------
255: -- Bug 4059844 - SQL Repository Perf
256: -- pay_payroll_actions pact,
257: pay_action_information pai
258: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
259: ('TRANSFER_PAYROLL_ACTION_ID')
260: AND act_edi.assignment_action_id = pai.action_context_id

Line 295: FROM pay_payroll_actions pact,

291: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD')
292: -to_date('06-04-'|| to_char(to_date(substr(pact.legislative_parameters,
293: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
294: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
295: FROM pay_payroll_actions pact,
296: hr_organization_information hoi
297: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
298: ('TRANSFER_PAYROLL_ACTION_ID')
299: AND hoi.org_information_context = 'Tax Details References'

Line 335: FROM pay_payroll_actions pact,

331: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD')
332: -to_date('06-04-'|| to_char(to_date(substr(pact.legislative_parameters,
333: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
334: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
335: FROM pay_payroll_actions pact,
336: hr_organization_information hoi
337: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
338: ('TRANSFER_PAYROLL_ACTION_ID')
339: AND hoi.org_information_context = 'Tax Details References'

Line 415: -- pay_payroll_actions pact,

411: -- pay_action_interlocks pail,
412: -- pay_assignment_actions act,
413: ----------------------------------------------------------
414: -- Bug 4059844 - SQL Repository Perf
415: -- pay_payroll_actions pact,
416: pay_action_information pai
417: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
418: ('TRANSFER_PAYROLL_ACTION_ID')
419: AND act_edi.assignment_action_id = pai.action_context_id