APPS.GHR_WGI_PKG dependencies on GHR_PAY_PLANS

Line 8: p_pay_plan IN ghr_pay_plans.pay_plan%TYPE

4: errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_personnel_office_id IN ghr_pa_requests.personnel_office_id%TYPE
7: DEFAULT NULL,
8: p_pay_plan IN ghr_pay_plans.pay_plan%TYPE
9: DEFAULT NULL
10: )
11: IS
12: l_errbuf VARCHAR2 (2000);

Line 44: p_pay_plan IN ghr_pay_plans.pay_plan%TYPE

40: p_errbuf OUT NOCOPY VARCHAR2,
41: p_retcode OUT NOCOPY NUMBER,
42: p_personnel_office_id IN ghr_pa_requests.personnel_office_id%TYPE
43: DEFAULT NULL,
44: p_pay_plan IN ghr_pay_plans.pay_plan%TYPE
45: DEFAULT NULL
46: )
47: IS
48: --

Line 106: l_pay_table_plan_id ghr_pay_plans.pay_plan%TYPE;

102: l_org_city hr_locations.town_or_city%TYPE;
103: l_org_state hr_locations.region_2%TYPE;
104: l_org_country hr_locations.country%TYPE;
105: l_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;
106: l_pay_table_plan_id ghr_pay_plans.pay_plan%TYPE;
107: l_wgi_pay_date DATE;
108: l_wgi_due_date DATE; -- Bug 3747024
109: l_value VARCHAR2 (30);
110: l_multiple_error_flag BOOLEAN;

Line 2382: CURSOR csr_pay_plan (p_pay_plan ghr_pay_plans.pay_plan%TYPE)

2378: --
2379: l_exists VARCHAR2 (1);
2380: l_pay_plan VARCHAR2(200);
2381:
2382: CURSOR csr_pay_plan (p_pay_plan ghr_pay_plans.pay_plan%TYPE)
2383: IS
2384: SELECT 'X'
2385: FROM ghr_pay_plans
2386: WHERE pay_plan = l_pay_plan AND wgi_enabled_flag = 'Y';

Line 2385: FROM ghr_pay_plans

2381:
2382: CURSOR csr_pay_plan (p_pay_plan ghr_pay_plans.pay_plan%TYPE)
2383: IS
2384: SELECT 'X'
2385: FROM ghr_pay_plans
2386: WHERE pay_plan = l_pay_plan AND wgi_enabled_flag = 'Y';
2387: --
2388: BEGIN
2389: l_pay_plan := p_pay_plan;

Line 2463: FROM ghr_pay_plans gpp

2459:
2460: CURSOR c_eq_pay_plan
2461: IS
2462: SELECT gpp.equivalent_pay_plan
2463: FROM ghr_pay_plans gpp
2464: WHERE gpp.pay_plan = l_from_pay_plan;
2465: --
2466: --
2467: BEGIN

Line 2760: FROM ghr_pay_plans

2756: --
2757: CURSOR csr_chk_fw_pp
2758: IS
2759: SELECT pay_plan
2760: FROM ghr_pay_plans
2761: WHERE pay_plan = p_from_pay_plan AND equivalent_pay_plan = 'FW';
2762: --
2763: BEGIN
2764: --

Line 2896: l_maximum_step ghr_pay_plans.maximum_step%TYPE;

2892: IS
2893: --
2894: -- Local variables
2895: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2896: l_maximum_step ghr_pay_plans.maximum_step%TYPE;
2897:
2898: --
2899: -- This function checks if the Pay plan is FW equivalent. If its the it returns TRUE otherwise FALSE
2900: --

Line 2905: FROM ghr_pay_plans

2901: --
2902: CURSOR csr_chk_max_pp
2903: IS
2904: SELECT maximum_step
2905: FROM ghr_pay_plans
2906: WHERE pay_plan = l_from_pay_plan;
2907: --
2908: BEGIN
2909: --