DBA Data[Home] [Help]

APPS.HR_PAYMENTS dependencies on PAY_PRE_PAYMENTS

Line 382: from pay_pre_payments pp

378: into dummy
379: from dual
380: where not exists(
381: select 1
382: from pay_pre_payments pp
383: where pp.org_payment_method_id = opm_id
384: and exists(
385: select 1
386: from pay_assignment_actions aa,

Line 711: pay_pre_payments pp

707: where not exists(
708: select 1
709: from pay_payroll_actions pa,
710: pay_assignment_actions aa,
711: pay_pre_payments pp
712: where pp.personal_payment_method_id = ppm_id
713: and pp.assignment_action_id = aa.assignment_action_id
714: and aa.payroll_action_id = pa.payroll_action_id
715: and pa.effective_date > fnd_date.canonical_to_date(val_start_date));

Line 787: pay_pre_payments pp

783: where not exists(
784: select 1
785: from pay_payroll_actions pa,
786: pay_assignment_actions aa,
787: pay_pre_payments pp
788: where pp.personal_payment_method_id = ppm_id
789: and pp.assignment_action_id = aa.assignment_action_id
790: and aa.payroll_action_id = pa.payroll_action_id
791: and pa.effective_date > eff_date);