APPS.PAY_IE_PYMT_SUMMARY_RPT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 153: pay_assignment_actions paa,

149: SUBSTR (pea.segment5, 1, 18) account_name,
150: SUM (TO_NUMBER (ppp.VALUE)) amount,
151: COUNT (ppp.VALUE) total_assignments_paid
152: FROM pay_payroll_actions ppa,
153: pay_assignment_actions paa,
154: pay_pre_payments ppp,
155: pay_org_payment_methods_f_tl popmftl,
156: pay_org_payment_methods_f popmf,
157: pay_payment_types_tl ppttl,

Line 189: FROM pay_assignment_actions paa_run,

185: popmf.org_payment_method_id
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

Line 225: pay_assignment_actions paa,

221: text_not_all_payroll_runs_paid
222: FROM DUAL
223: WHERE EXISTS ( SELECT NULL
224: FROM pay_payroll_actions ppa,
225: pay_assignment_actions paa,
226: per_time_periods ptp -- Bug 5070091 Offset payroll change
227: WHERE paa.payroll_action_id = ppa.payroll_action_id
228: AND ppa.action_status = 'C'
229: AND ppa.action_type IN ('Q', 'R')

Line 237: pay_assignment_actions paa1,

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
241: AND paa1.payroll_action_id = ppa1.payroll_action_id

Line 255: pay_assignment_actions paa,

251: payroll period(s) ***'
252: payments_from_previous_periods
253: FROM /* per_time_periods ptp, */
254: pay_payroll_actions ppa,
255: pay_assignment_actions paa,
256: pay_pre_payments ppp
257: WHERE paa.payroll_action_id = ppa.payroll_action_id
258: AND ( p_consolidation_set_id IS NULL
259: OR ppa.consolidation_set_id = p_consolidation_set_id

Line 270: pay_assignment_actions paa1,

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
274: AND pai.locked_action_id = paa1.assignment_action_id

Line 285: pay_assignment_actions paa2,

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
289: AND pai2.locked_action_id = paa2.assignment_action_id