DBA Data[Home] [Help]

APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 439: FROM pay_action_interlocks pai

435: CURSOR csr_all_runs_under_prepay(p_pre_assignment_action_id NUMBER)
436: IS
437: SELECT pac.assignment_action_id
438: ,pac.source_action_id
439: FROM pay_action_interlocks pai
440: ,pay_assignment_actions pac
441: ,pay_payroll_Actions ppa
442: WHERE pai.locking_action_id = p_pre_assignment_action_id
443: AND pai.locked_action_id = pac.assignment_action_id