DBA Data[Home] [Help]

APPS.PAY_IE_PYMT_SUMMARY_RPT_PKG dependencies on PAY_PRE_PAYMENTS

Line 154: pay_pre_payments ppp,

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,
158: pay_payment_types ppt,

Line 256: pay_pre_payments ppp

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
260: )