DBA Data[Home] [Help]

APPS.PAY_HK_IR56_MAGTAPE dependencies on PAY_ACTION_INTERLOCKS

Line 127: from pay_action_interlocks pai,

123: and ppa3.action_status = 'C'
124: and paa.action_status = 'C' /* Bug No : 2829320 - To prevent Magtape fetching errored archive records */
125: and not exists /* dont process locked assignments, bug 7324233, it should only lock the assignments which has magtape generated previously */
126: (select locked_action_id
127: from pay_action_interlocks pai,
128: pay_payroll_actions ppa1,
129: pay_payroll_actions ppa2,
130: pay_assignment_actions paa1
131: where pai.locked_action_id = paa.assignment_action_id