APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_ACTION_INFORMATION

Line 115: pay_action_information pai

111: -- pay_assignment_actions act,
112: ----------------------------------------------------------
113: -- Bug 4059844 - SQL Repository Perf
114: -- pay_payroll_actions pact,
115: pay_action_information pai
116: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
117: ('TRANSFER_PAYROLL_ACTION_ID')
118: AND act_edi.assignment_action_id = pai.action_context_id
119: AND pai.action_context_type = 'AAP'

Line 152: pay_action_information pai

148: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
149: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' ')
150: FROM pay_assignment_actions act_edi,
151: per_all_assignments_f asg,
152: pay_action_information pai
153: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
154: ('TRANSFER_PAYROLL_ACTION_ID')
155: AND asg.person_id = pay_magtape_generic.get_parameter_value(
156: 'PERSON_ID')

Line 234: pay_action_information pai

230: -- pay_assignment_actions act,
231: ----------------------------------------------------------
232: -- Bug 4059844 - SQL Repository Perf
233: -- pay_payroll_actions pact,
234: pay_action_information pai
235: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
236: ('TRANSFER_PAYROLL_ACTION_ID')
237: AND act_edi.assignment_action_id = pai.action_context_id
238: AND pai.action_context_type = 'AAP'

Line 271: pay_action_information pai

267: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
268: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' ')
269: FROM pay_assignment_actions act_edi,
270: per_all_assignments_f asg,
271: pay_action_information pai
272: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
273: ('TRANSFER_PAYROLL_ACTION_ID')
274: AND asg.person_id = pay_magtape_generic.get_parameter_value(
275: 'PERSON_ID')