APPS.GHR_PAY_CALC dependencies on GHR_PAY_PLANS

Line 1814: from ghr_pay_plans

1810: -- Bug#6154261
1811: cursor espayplan
1812: is
1813: select 1
1814: from ghr_pay_plans
1815: where equivalent_pay_plan = 'ES'
1816: and pay_plan = l_pay_plan;
1817:
1818: esplan_flag varchar2(1);

Line 3723: FROM ghr_pay_plans ppl

3719: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type)
3720: RETURN BOOLEAN IS
3721: CURSOR cur_ppl(p_pay_plan VARCHAR2) IS
3722: SELECT 1
3723: FROM ghr_pay_plans ppl
3724: WHERE ppl.pay_plan = p_pay_plan
3725: AND ppl.equivalent_pay_plan = 'GS';
3726:
3727: CURSOR cur_ppl_fw(p_pay_plan VARCHAR2) IS --5218445

Line 3729: FROM ghr_pay_plans ppl

3725: AND ppl.equivalent_pay_plan = 'GS';
3726:
3727: CURSOR cur_ppl_fw(p_pay_plan VARCHAR2) IS --5218445
3728: SELECT 1
3729: FROM ghr_pay_plans ppl
3730: WHERE ppl.pay_plan = p_pay_plan
3731: AND ppl.equivalent_pay_plan = 'FW';
3732:
3733: l_pay_plan VARCHAR2(30);

Line 4991: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

4987: l_pay_table VARCHAR2(4);
4988: l_PT_value NUMBER;
4989: l_PT_eff_start_date DATE;
4990: l_PT_eff_end_date DATE;
4991: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
4992: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%type;
4993: l_max_step ghr_pay_plans.maximum_step%type;
4994: l_locality_adj NUMBER;
4995: l_leo_flag BOOLEAN;

Line 4993: l_max_step ghr_pay_plans.maximum_step%type;

4989: l_PT_eff_start_date DATE;
4990: l_PT_eff_end_date DATE;
4991: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
4992: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%type;
4993: l_max_step ghr_pay_plans.maximum_step%type;
4994: l_locality_adj NUMBER;
4995: l_leo_flag BOOLEAN;
4996: l_std_user_table_id NUMBER;
4997: l_std_user_table_name varchar2(80);

Line 5010: FROM ghr_pay_plans

5006: --bug #5482191
5007: l_psi VARCHAR2(30);
5008: cursor c_gs_eq(pc_pay_plan VARCHAR2) is
5009: SELECT equivalent_pay_plan,maximum_step
5010: FROM ghr_pay_plans
5011: WHERE pay_plan = pc_pay_plan;
5012:
5013: CURSOR get_user_table_id(p_user_table_name VARCHAR2) IS
5014: SELECT utb.user_table_id