DBA Data[Home] [Help]

APPS.HR_PAYMENTS dependencies on PAY_PRE_PAYMENTS

Line 377: from pay_pre_payments pp

373: into dummy
374: from dual
375: where not exists(
376: select 1
377: from pay_pre_payments pp
378: where pp.org_payment_method_id = opm_id
379: and exists(
380: select 1
381: from pay_assignment_actions aa,

Line 706: pay_pre_payments pp

702: where not exists(
703: select 1
704: from pay_payroll_actions pa,
705: pay_assignment_actions aa,
706: pay_pre_payments pp
707: where pp.personal_payment_method_id = ppm_id
708: and pp.assignment_action_id = aa.assignment_action_id
709: and aa.payroll_action_id = pa.payroll_action_id
710: and pa.effective_date > fnd_date.canonical_to_date(val_start_date));