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 2378: CURSOR csr_pay_plan (p_pay_plan ghr_pay_plans.pay_plan%TYPE)

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

Line 2381: FROM ghr_pay_plans

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

Line 2459: FROM ghr_pay_plans gpp

2455:
2456: CURSOR c_eq_pay_plan
2457: IS
2458: SELECT gpp.equivalent_pay_plan
2459: FROM ghr_pay_plans gpp
2460: WHERE gpp.pay_plan = l_from_pay_plan;
2461: --
2462: --
2463: BEGIN

Line 2756: FROM ghr_pay_plans

2752: --
2753: CURSOR csr_chk_fw_pp
2754: IS
2755: SELECT pay_plan
2756: FROM ghr_pay_plans
2757: WHERE pay_plan = p_from_pay_plan AND equivalent_pay_plan = 'FW';
2758: --
2759: BEGIN
2760: --

Line 2892: l_maximum_step ghr_pay_plans.maximum_step%TYPE;

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

Line 2901: FROM ghr_pay_plans

2897: --
2898: CURSOR csr_chk_max_pp
2899: IS
2900: SELECT maximum_step
2901: FROM ghr_pay_plans
2902: WHERE pay_plan = l_from_pay_plan;
2903: --
2904: BEGIN
2905: --