APPS.PAY_IE_PYMT_SUMMARY_RPT_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 190: pay_action_interlocks pai_run,

186: AND popmf.payment_type_id = ppt.payment_type_id
187: AND popmf.external_account_id = pea.external_account_id
188: AND exists ( SELECT NULL -- Bug 5070091 Offset payroll Change
189: FROM pay_assignment_actions paa_run,
190: pay_action_interlocks pai_run,
191: pay_payroll_actions ppa_run
192: WHERE ppa_run.payroll_id = p_payroll_id
193: AND ptp.time_period_id = p_period_id
194: AND ppa_run.date_earned between ptp.start_date and ptp.end_date

Line 236: FROM pay_action_interlocks pai,

232: AND ppa.date_earned between ptp.start_date and ptp.end_date
233: --AND ppa.time_period_id = p_period_id
234: AND NOT EXISTS (
235: SELECT 1
236: FROM pay_action_interlocks pai,
237: pay_assignment_actions paa1,
238: pay_payroll_actions ppa1
239: WHERE pai.locked_action_id = paa.assignment_action_id
240: AND pai.locking_action_id = paa1.assignment_action_id

Line 269: FROM pay_action_interlocks pai,

265: AND ppa.action_type IN ('U', 'P')
266: AND ppp.assignment_action_id = paa.assignment_action_id
267: AND EXISTS (
268: SELECT 1
269: FROM pay_action_interlocks pai,
270: pay_assignment_actions paa1,
271: pay_payroll_actions ppa1,
272: per_time_periods ptp1
273: WHERE pai.locking_action_id = paa.assignment_action_id

Line 284: FROM pay_action_interlocks pai2,

280: AND ptp1.time_period_id <> p_period_id)
281: --AND ppa1.time_period_id <> ptp.time_period_id);
282: AND EXISTS (
283: SELECT 1
284: FROM pay_action_interlocks pai2,
285: pay_assignment_actions paa2,
286: pay_payroll_actions ppa2,
287: per_time_periods ptp2
288: WHERE pai2.locking_action_id = paa.assignment_action_id