DBA Data[Home] [Help]

APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 205: pay_action_interlocks pai_xfr,

201:
202: CURSOR csr_get_chk_no IS
203: SELECT paa_chk.serial_number
204: FROM pay_assignment_actions paa_xfr,
205: pay_action_interlocks pai_xfr,
206: pay_action_interlocks pai_chk,
207: pay_assignment_actions paa_chk,
208: pay_payroll_actions ppa_chk
209: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id

Line 206: pay_action_interlocks pai_chk,

202: CURSOR csr_get_chk_no IS
203: SELECT paa_chk.serial_number
204: FROM pay_assignment_actions paa_xfr,
205: pay_action_interlocks pai_xfr,
206: pay_action_interlocks pai_chk,
207: pay_assignment_actions paa_chk,
208: pay_payroll_actions ppa_chk
209: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
210: AND pai_xfr.locked_action_id = pai_chk.locked_action_id