DBA Data[Home] [Help]

APPS.HR_PAYMENTS dependencies on PAY_PAYROLL_ACTIONS

Line 382: pay_payroll_actions pa

378: where pp.org_payment_method_id = opm_id
379: and exists(
380: select 1
381: from pay_assignment_actions aa,
382: pay_payroll_actions pa
383: where pp.assignment_action_id = aa.assignment_action_id
384: and aa.payroll_action_id = pa.payroll_action_id
385: and pa.effective_date >=
386: fnd_date.canonical_to_date(val_start_date)));

Line 704: from pay_payroll_actions pa,

700: into status
701: from sys.dual
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