APPS.GHR_LACS_REMARKS dependencies on GHR_PAY_PLANS

Line 14: g_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%TYPE;

10: g_pay_table_id VARCHAR2(4);
11: g_new_prd VARCHAR2(10);
12: g_leo_posn_indicator per_position_extra_info.poei_information16%TYPE;
13: g_intl_posn_indicator per_position_extra_info.poei_information15%TYPE; ---- variable declared for Bug#4130683
14: g_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%TYPE;
15: l_pos_extra_info_rec per_position_extra_info%ROWTYPE;
16: l_package VARCHAR2(30) := 'GHR_LACS_REMARKS';
17: l_location VARCHAR2(200);
18:

Line 112: FROM ghr_pay_plans

108: g_intl_posn_indicator := NVL(l_pos_extra_info_rec.poei_information15,'0'); -- variable for Bug#4130683
109: -- Fetch Equivalent Pay Plan
110: SELECT equivalent_pay_plan
111: INTO g_equivalent_pay_plan
112: FROM ghr_pay_plans
113: WHERE pay_plan = g_pay_plan;
114:
115: END;
116: