DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on PAY_ACTION_INTERLOCKS

Line 284: pay_action_interlocks AI,

280: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
281: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
282: FROM pay_payroll_actions PA,
283: pay_assignment_actions AA,
284: pay_action_interlocks AI,
285: per_all_assignments_f SS,
286: per_all_people_f PE
287: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
288: ('TRANSFER_PAYROLL_ACTION_ID')

Line 317: pay_action_interlocks AI,

313: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
314: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
315: FROM per_all_people_f PE,
316: per_all_assignments_f SS,
317: pay_action_interlocks AI,
318: pay_assignment_actions AA,
319: pay_assignment_actions paa,
320: pay_payroll_actions PA,
321: ff_archive_items arch,

Line 365: pay_action_interlocks AI,

361: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
362: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
363: FROM per_all_people_f PE,
364: per_all_assignments_f SS,
365: pay_action_interlocks AI,
366: pay_assignment_actions AA,
367: pay_payroll_actions PA
368: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
369: ('TRANSFER_PAYROLL_ACTION_ID')