APPS.GHR_PAY_CALC dependencies on GHR_PAY_PLANS

Line 1868: from ghr_pay_plans

1864: -- Bug#6154261
1865: cursor espayplan
1866: is
1867: select 'Y'
1868: from ghr_pay_plans
1869: where equivalent_pay_plan = 'ES'
1870: and pay_plan = l_pay_plan;
1871:
1872: esplan_flag varchar2(1);

Line 1907: sl_eql_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

1903: l_default_pay_plan VARCHAR2(5);
1904: ------ GPPA Update 46 end
1905:
1906: --Begin Bug# 8453042
1907: sl_eql_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
1908:
1909: cursor c_sl_eql_pp is
1910: select equivalent_pay_plan from ghr_pay_plans
1911: where PAY_PLAN = l_pay_plan;

Line 1910: select equivalent_pay_plan from ghr_pay_plans

1906: --Begin Bug# 8453042
1907: sl_eql_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
1908:
1909: cursor c_sl_eql_pp is
1910: select equivalent_pay_plan from ghr_pay_plans
1911: where PAY_PLAN = l_pay_plan;
1912: --End Bug# 8453042
1913:
1914: --Bug # 9513518

Line 3937: FROM ghr_pay_plans ppl

3933: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type)
3934: RETURN BOOLEAN IS
3935: CURSOR cur_ppl(p_pay_plan VARCHAR2) IS
3936: SELECT 1
3937: FROM ghr_pay_plans ppl
3938: WHERE ppl.pay_plan = p_pay_plan
3939: AND ppl.equivalent_pay_plan = 'GS';
3940:
3941: CURSOR cur_ppl_fw(p_pay_plan VARCHAR2) IS --5218445

Line 3943: FROM ghr_pay_plans ppl

3939: AND ppl.equivalent_pay_plan = 'GS';
3940:
3941: CURSOR cur_ppl_fw(p_pay_plan VARCHAR2) IS --5218445
3942: SELECT 1
3943: FROM ghr_pay_plans ppl
3944: WHERE ppl.pay_plan = p_pay_plan
3945: AND ppl.equivalent_pay_plan = 'FW';
3946:
3947: l_pay_plan VARCHAR2(30);

Line 4177: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

4173: l_from_pay_plan ghr_pa_requests.from_pay_plan%type;
4174: l_from_grade_id NUMBER;
4175: l_from_pos_ind VARCHAR2(30);
4176: l_to_pos_ind VARCHAR2(30);
4177: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
4178: l_session ghr_history_api.g_session_var_type;
4179:
4180:
4181: cursor get_equi_pay_plan(p_pay_plan in varchar2)

Line 4184: from ghr_pay_plans

4180:
4181: cursor get_equi_pay_plan(p_pay_plan in varchar2)
4182: is
4183: select equivalent_pay_plan
4184: from ghr_pay_plans
4185: where pay_plan = p_pay_plan;
4186:
4187: cursor get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type,
4188: c_effective_date IN ghr_pa_requests.effective_date%type)

Line 5340: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

5336: l_pay_table VARCHAR2(4);
5337: l_PT_value NUMBER;
5338: l_PT_eff_start_date DATE;
5339: l_PT_eff_end_date DATE;
5340: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
5341: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%type;
5342: l_max_step ghr_pay_plans.maximum_step%type;
5343: l_locality_adj NUMBER;
5344: l_leo_flag BOOLEAN;

Line 5342: l_max_step ghr_pay_plans.maximum_step%type;

5338: l_PT_eff_start_date DATE;
5339: l_PT_eff_end_date DATE;
5340: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
5341: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%type;
5342: l_max_step ghr_pay_plans.maximum_step%type;
5343: l_locality_adj NUMBER;
5344: l_leo_flag BOOLEAN;
5345: l_std_user_table_id NUMBER;
5346: l_std_user_table_name varchar2(80);

Line 5359: FROM ghr_pay_plans

5355: --bug #5482191
5356: l_psi VARCHAR2(30);
5357: cursor c_gs_eq(pc_pay_plan VARCHAR2) is
5358: SELECT equivalent_pay_plan,maximum_step
5359: FROM ghr_pay_plans
5360: WHERE pay_plan = pc_pay_plan;
5361:
5362: CURSOR get_user_table_id(p_user_table_name VARCHAR2) IS
5363: SELECT utb.user_table_id