DBA Data[Home] [Help]

APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 437: FROM pay_action_interlocks pai

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