APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 113: AND EXISTS (SELECT 1 FROM pay_assignment_actions act

109: SELECT effective_date
110: FROM pay_payroll_actions pact
111: WHERE action_type IN ('Q','R')
112: AND action_status = 'C'
113: AND EXISTS (SELECT 1 FROM pay_assignment_actions act
114: WHERE act.payroll_action_id = pact.payroll_action_id
115: AND assignment_id = p_assignment_id
116: AND action_status = 'C')
117: AND effective_date >= c_eff_dt

Line 311: FROM pay_assignment_actions paa

307: WHERE ppa.action_status = 'C'
308: AND ppa.action_type IN ('Q','R')
309: AND ppa.effective_date >= p_effective_date
310: AND EXISTS ( SELECT 1
311: FROM pay_assignment_actions paa
312: WHERE ppa.payroll_action_id = paa.payroll_action_id
313: AND paa.assignment_id = p_assignment_id
314: AND paa.action_status = 'C' )
315: AND rownum = 1;

Line 1119: FROM pay_assignment_actions paa,pay_payroll_actions ppa

1115: --payroll actions between the old start and end dates , and which have
1116: -- a run result for this current old pension type
1117: CURSOR c_run_results_exist IS
1118: SELECT paa.assignment_id,ppa.date_earned
1119: FROM pay_assignment_actions paa,pay_payroll_actions ppa
1120: WHERE paa.payroll_action_id = ppa.payroll_action_id
1121: AND ppa.date_earned between
1122: fnd_date.canonical_to_date(p_org_information1_o)
1123: AND fnd_date.canonical_to_date(nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot)))

Line 2893: FROM pay_assignment_actions paa,pay_payroll_actions ppa

2889: where assignment_id = p_assignment_id;
2890:
2891: CURSOR c_run_results_exist IS
2892: SELECT ppa.date_earned
2893: FROM pay_assignment_actions paa,pay_payroll_actions ppa
2894: WHERE paa.payroll_action_id = ppa.payroll_action_id
2895: AND paa.assignment_id = p_assignment_id
2896: AND ppa.date_earned between
2897: fnd_date.canonical_to_date(p_aei_information1_o)