DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on PAY_ACTION_INTERLOCKS

Line 294: pay_action_interlocks AI,

290: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
291: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
292: FROM pay_payroll_actions PA,
293: pay_assignment_actions AA,
294: pay_action_interlocks AI,
295: per_all_assignments_f SS,
296: per_all_people_f PE
297: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
298: ('TRANSFER_PAYROLL_ACTION_ID')

Line 327: pay_action_interlocks AI,

323: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
324: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
325: FROM per_all_people_f PE,
326: per_all_assignments_f SS,
327: pay_action_interlocks AI,
328: pay_assignment_actions AA,
329: pay_assignment_actions paa,
330: pay_payroll_actions PA,
331: ff_archive_items arch,

Line 375: pay_action_interlocks AI,

371: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
372: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
373: FROM per_all_people_f PE,
374: per_all_assignments_f SS,
375: pay_action_interlocks AI,
376: pay_assignment_actions AA,
377: pay_payroll_actions PA
378: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
379: ('TRANSFER_PAYROLL_ACTION_ID')