APPS.GHR_PAY_CAPS dependencies on GHR_PAY_PLANS

Line 11: FROM ghr_pay_plans ppl

7: FUNCTION pp_fw_equivalent (p_pay_plan IN VARCHAR2)
8: RETURN BOOLEAN IS
9: CURSOR cur_ppl IS
10: SELECT 1
11: FROM ghr_pay_plans ppl
12: WHERE ppl.pay_plan = p_pay_plan
13: AND ppl.equivalent_pay_plan = 'FW';
14: --
15: BEGIN

Line 29: FROM ghr_pay_plans ppl

25: FUNCTION pp_gs_equivalent (p_pay_plan IN VARCHAR2)
26: RETURN BOOLEAN IS
27: CURSOR cur_ppl IS
28: SELECT 1
29: FROM ghr_pay_plans ppl
30: WHERE ppl.pay_plan = p_pay_plan
31: AND ppl.equivalent_pay_plan = 'GS';
32: --
33: BEGIN

Line 168: p_pay_plan ghr_pay_plans.pay_plan%TYPE)

164: and asg.effective_end_date;
165: --
166: CURSOR cur_perf_cert_agency(p_eff_date date,
167: p_agency_code ghr_pa_Requests.agency_code%TYPE,
168: p_pay_plan ghr_pay_plans.pay_plan%TYPE)
169: IS
170: SELECT distinct cert_group
171: FROM ghr_perf_cert
172: WHERE cert_agency = substr(p_agency_code,1,2)

Line 180: p_pay_plan ghr_pay_plans.pay_plan%TYPE)

176: AND ( INSTR(cert_group,p_pay_plan) > 0 );
177: --
178: CURSOR cur_perf_cert_agency_sub(p_eff_date date,
179: p_agency_sub_code ghr_pa_Requests.agency_code%TYPE,
180: p_pay_plan ghr_pay_plans.pay_plan%TYPE)
181: IS
182: SELECT cert_group
183: FROM ghr_perf_cert
184: WHERE cert_agency IS NULL

Line 193: p_pay_plan ghr_pay_plans.pay_plan%TYPE)

189: --
190:
191: CURSOR cur_perf_cert_org(p_eff_date date,
192: p_org_id per_positions.organization_id%TYPE,
193: p_pay_plan ghr_pay_plans.pay_plan%TYPE)
194: IS
195: SELECT cert_group
196: FROM ghr_perf_cert
197: WHERE cert_agency IS NULL

Line 204: CURSOR cur_ESSL_equivalent(p_pay_plan ghr_pay_plans.pay_plan%TYPE)

200: AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )
201: AND ( INSTR(cert_group,p_pay_plan) > 0 );
202: --
203: --
204: CURSOR cur_ESSL_equivalent(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
205: IS
206: SELECT equivalent_pay_plan
207: FROM ghr_pay_plans ppl
208: WHERE ppl.pay_plan = p_pay_plan;

Line 207: FROM ghr_pay_plans ppl

203: --
204: CURSOR cur_ESSL_equivalent(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
205: IS
206: SELECT equivalent_pay_plan
207: FROM ghr_pay_plans ppl
208: WHERE ppl.pay_plan = p_pay_plan;
209: --
210: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;
211: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;

Line 210: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;

206: SELECT equivalent_pay_plan
207: FROM ghr_pay_plans ppl
208: WHERE ppl.pay_plan = p_pay_plan;
209: --
210: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;
211: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;
212: l_cert_group ghr_perf_cert.cert_group%type;
213: l_business_group_id per_positions.organization_id%TYPE;
214: --