DBA Data[Home] [Help]

APPS.HR_PAYMENTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 386: from pay_assignment_actions aa,

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,
387: pay_payroll_actions pa
388: where pp.assignment_action_id = aa.assignment_action_id
389: and aa.payroll_action_id = pa.payroll_action_id
390: and pa.effective_date >=

Line 710: pay_assignment_actions aa,

706: from sys.dual
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

Line 786: pay_assignment_actions aa,

782: from sys.dual
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