APPS.HR_PRE_PAY dependencies on PAY_CONTRIBUTING_PAYMENTS

Line 3454: from pay_contributing_payments pcp

3450: and ppp.organization_id is not null
3451: and nvl(ppp.effective_date , ppa_pre.effective_date)
3452: <= ppa_pru.effective_date
3453: and not exists (select ''
3454: from pay_contributing_payments pcp
3455: where ppp.pre_payment_id = pcp.contributing_pre_payment_id)
3456: order by ppp.org_payment_method_id, ppp.payees_org_payment_method_id
3457: for update of ppp.pre_payment_id;
3458: --

Line 3470: insert into pay_contributing_payments

3466: f_payroll_action_id
3467: limit 1000;
3468: --
3469: forall i in 1..f_pre_payment_id.count
3470: insert into pay_contributing_payments
3471: (assignment_action_id,
3472: payroll_action_id,
3473: contributing_pre_payment_id
3474: )

Line 3499: from pay_contributing_payments pcp,

3495: ppp.payees_org_payment_method_id,
3496: ppp.organization_id,
3497: sum(nvl(base_currency_value, 0)) base_currency_value,
3498: sum(nvl(value,0)) value
3499: from pay_contributing_payments pcp,
3500: pay_pre_payments ppp
3501: where pcp.payroll_action_id = p_pactid
3502: and pcp.contributing_pre_payment_id = ppp.pre_payment_id
3503: group by ppp.org_payment_method_id,

Line 3534: update pay_contributing_payments pcp

3530: totrec.organization_id,
3531: totrec.payees_org_payment_method_id,
3532: p_pactid);
3533: --
3534: update pay_contributing_payments pcp
3535: set pre_payment_id = l_pre_pay_id
3536: where pcp.payroll_action_id = p_pactid
3537: and exists (select ''
3538: from pay_pre_payments ppp