eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 169: p_pay_plan ghr_pay_plans.pay_plan%TYPE,

165: and asg.effective_end_date;
166: --
167: CURSOR cur_perf_cert_agency(p_eff_date date,
168: p_agency_code ghr_pa_Requests.agency_code%TYPE,
169: p_pay_plan ghr_pay_plans.pay_plan%TYPE,
170: p_business_group_id number)
171: IS
172: SELECT distinct cert_group
173: FROM ghr_perf_cert

Line 184: p_pay_plan ghr_pay_plans.pay_plan%TYPE,

180: AND NVL(business_group_id,p_business_group_id) = p_business_group_id;
181: --
182: CURSOR cur_perf_cert_agency_sub(p_eff_date date,
183: p_agency_sub_code ghr_pa_Requests.agency_code%TYPE,
184: p_pay_plan ghr_pay_plans.pay_plan%TYPE,
185: p_business_group_id number)
186: IS
187: SELECT cert_group
188: FROM ghr_perf_cert

Line 200: p_pay_plan ghr_pay_plans.pay_plan%TYPE,

196: --
197:
198: CURSOR cur_perf_cert_org(p_eff_date date,
199: p_org_id per_positions.organization_id%TYPE,
200: p_pay_plan ghr_pay_plans.pay_plan%TYPE,
201: p_business_group_id number)
202: IS
203: SELECT cert_group
204: FROM ghr_perf_cert

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

211: AND NVL(business_group_id,p_business_group_id) = p_business_group_id;
212:
213: --
214: --
215: CURSOR cur_ESSL_equivalent(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
216: IS
217: SELECT equivalent_pay_plan
218: FROM ghr_pay_plans ppl
219: WHERE ppl.pay_plan = p_pay_plan;

Line 218: FROM ghr_pay_plans ppl

214: --
215: CURSOR cur_ESSL_equivalent(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
216: IS
217: SELECT equivalent_pay_plan
218: FROM ghr_pay_plans ppl
219: WHERE ppl.pay_plan = p_pay_plan;
220: --
221: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;
222: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;

Line 221: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;

217: SELECT equivalent_pay_plan
218: FROM ghr_pay_plans ppl
219: WHERE ppl.pay_plan = p_pay_plan;
220: --
221: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;
222: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;
223: l_cert_group ghr_perf_cert.cert_group%type;
224: l_business_group_id per_positions.organization_id%TYPE;
225: --