DBA Data[Home] [Help]

APPS.PAY_FI_RULES dependencies on PAY_ACTION_INTERLOCKS

Line 545: pay_action_interlocks pai_xfr,

541:
542: CURSOR csr_get_chk_no IS
543: SELECT paa_chk.serial_number
544: FROM pay_assignment_actions paa_xfr,
545: pay_action_interlocks pai_xfr,
546: pay_action_interlocks pai_chk,
547: pay_assignment_actions paa_chk,
548: pay_payroll_actions ppa_chk
549: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id

Line 546: pay_action_interlocks pai_chk,

542: CURSOR csr_get_chk_no IS
543: SELECT paa_chk.serial_number
544: FROM pay_assignment_actions paa_xfr,
545: pay_action_interlocks pai_xfr,
546: pay_action_interlocks pai_chk,
547: pay_assignment_actions paa_chk,
548: pay_payroll_actions ppa_chk
549: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
550: AND pai_xfr.locked_action_id = pai_chk.locked_action_id