DBA Data[Home] [Help]

APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 236: pay_action_interlocks pai_xfr,

232:
233: CURSOR csr_get_chk_no IS
234: SELECT paa_chk.serial_number
235: FROM pay_assignment_actions paa_xfr,
236: pay_action_interlocks pai_xfr,
237: pay_action_interlocks pai_chk,
238: pay_assignment_actions paa_chk,
239: pay_payroll_actions ppa_chk
240: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id

Line 237: pay_action_interlocks pai_chk,

233: CURSOR csr_get_chk_no IS
234: SELECT paa_chk.serial_number
235: FROM pay_assignment_actions paa_xfr,
236: pay_action_interlocks pai_xfr,
237: pay_action_interlocks pai_chk,
238: pay_assignment_actions paa_chk,
239: pay_payroll_actions ppa_chk
240: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
241: AND pai_xfr.locked_action_id = pai_chk.locked_action_id