DBA Data[Home] [Help]

APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_ACTION_INTERLOCKS

Line 33: from pay_action_interlocks

29: 25-Jun-98 Vipin Mehta 40.0 Date created.
30:
31: 13-Aug-98 Vipin Mehta 40.1 changed ohstw2_supp and instw2_supp
32: to pick up assignment_action_id
33: from pay_action_interlocks
34: changed ohstw2_supp and
35: magw2_transmitter to set up an
36: additional parameter
37: (TRANSFER_SCHOOL_DISTRICT) to pass

Line 172: pay_action_interlocks AI,

168: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
169: (PA.effective_date, AA.assignment_id))
170: FROM per_people_f PE,
171: per_assignments_f SS,
172: pay_action_interlocks AI,
173: pay_assignment_actions AA,
174: pay_payroll_actions PA
175: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
176: ('TRANSFER_PAYROLL_ACTION_ID') AND

Line 235: pay_action_interlocks AI,

231: 'JURISDICTION_CODE=C', SR.jurisdiction_code
232: FROM per_people_f PE,
233: per_assignments_f SS,
234: pay_state_rules SR,
235: pay_action_interlocks AI,
236: pay_assignment_actions AA,
237: pay_payroll_actions PA
238: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
239: ('TRANSFER_PAYROLL_ACTION_ID') AND

Line 268: pay_action_interlocks AI,

264: 'DATE_EARNED=P', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
265: (PA.effective_date, AA.assignment_id))
266: FROM per_people_f PE,
267: per_assignments_f SS,
268: pay_action_interlocks AI,
269: pay_assignment_actions AA,
270: pay_payroll_actions PA
271: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
272: ('TRANSFER_PAYROLL_ACTION_ID') AND