DBA Data[Home] [Help]

APPS.HR_PAYMENTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 381: from pay_assignment_actions aa,

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,
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 >=

Line 705: pay_assignment_actions aa,

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
709: and aa.payroll_action_id = pa.payroll_action_id