APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 110: FROM pay_payroll_actions pact

106: ORDER BY ext_rslt_id DESC;
107:
108: CURSOR c_ppa_dt (c_eff_dt IN DATE) IS
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

Line 306: FROM pay_payroll_actions ppa

302: -- payroll has been processed.
303: --
304: CURSOR c_ass_act IS
305: SELECT 1
306: FROM pay_payroll_actions ppa
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

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)

Line 4870: FROM pay_payroll_actions

4866: BEGIN
4867:
4868: SELECT effective_date, date_earned
4869: INTO l_eff_dt , l_dt_earned
4870: FROM pay_payroll_actions
4871: WHERE payroll_action_id = p_payroll_action_id;
4872:
4873: IF to_char(l_eff_dt,'YYYY') <> to_char(l_dt_earned,'YYYY') THEN
4874: RETURN 1 ;

Line 5099: FROM pay_payroll_actions

5095: -- are calculated as per AAOP percentages.
5096: --
5097: SELECT effective_date
5098: INTO l_date_earned
5099: FROM pay_payroll_actions
5100: WHERE payroll_action_id = p_payroll_action_id;
5101:
5102: l_abp_sub_cat := 'AAOP';
5103:

Line 5137: FROM pay_payroll_actions

5133: l_abp_sub_cat := 'AAOP';
5134:
5135: SELECT effective_date
5136: INTO l_date_earned
5137: FROM pay_payroll_actions
5138: WHERE payroll_action_id = p_payroll_action_id;
5139:
5140: END IF;
5141:

Line 5152: FROM pay_payroll_actions

5148: ELSE
5149:
5150: SELECT effective_date
5151: INTO l_date_earned
5152: FROM pay_payroll_actions
5153: WHERE payroll_action_id = p_payroll_action_id;
5154:
5155: END IF;
5156: