APPS.GHR_MLC_PKG dependencies on GHR_PAY_PLANS

Line 3227: from ghr_pay_plans

3223: FUNCTION GET_PAY_PLAN_NAME (PP IN VARCHAR2) RETURN VARCHAR2 IS
3224:
3225: CURSOR CUR_PP IS
3226: select pay_plan,description
3227: from ghr_pay_plans
3228: WHERE PAY_PLAN = PP;
3229: l_pp_desc varchar2(150);
3230: BEGIN
3231: FOR PP_REC IN CUR_PP

Line 3502: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)

3498: return boolean is
3499:
3500: l_proc varchar2(72) := g_package || '.check_eligibility';
3501:
3502: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
3503: IS
3504: SELECT 1
3505: FROM ghr_pay_plans
3506: WHERE equivalent_pay_plan ='ES'

Line 3505: FROM ghr_pay_plans

3501:
3502: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
3503: IS
3504: SELECT 1
3505: FROM ghr_pay_plans
3506: WHERE equivalent_pay_plan ='ES'
3507: AND pay_plan=p_pay_plan;
3508:
3509: BEGIN

Line 3598: FROM ghr_pay_plans

3594: group by pr.pa_request_id;
3595:
3596: cursor csr_eq_pay_plan is
3597: SELECT equivalent_pay_plan
3598: FROM ghr_pay_plans
3599: WHERE pay_plan = p_pay_plan;
3600:
3601: cursor pa_hist_cur (p_r_hist_id number) is
3602: select nvl(action_taken,' ') action_taken

Line 3608: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

3604: where pa_routing_history_id = p_r_hist_id;
3605:
3606: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3607: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';
3608: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3609:
3610: begin
3611: g_proc := 'person_in_pa_req_1noa';
3612: hr_utility.set_location('Entering ' || l_proc,5);

Line 3678: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)

3674: return boolean is
3675:
3676: l_proc varchar2(72) := g_package || '.check_eligibility';
3677:
3678: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
3679: IS
3680: SELECT 1
3681: FROM ghr_pay_plans
3682: WHERE equivalent_pay_plan ='ES'

Line 3681: FROM ghr_pay_plans

3677:
3678: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
3679: IS
3680: SELECT 1
3681: FROM ghr_pay_plans
3682: WHERE equivalent_pay_plan ='ES'
3683: AND pay_plan=p_pay_plan;
3684:
3685: BEGIN

Line 3772: FROM ghr_pay_plans

3768: group by pr.pa_request_id;
3769:
3770: cursor csr_eq_pay_plan is
3771: SELECT equivalent_pay_plan
3772: FROM ghr_pay_plans
3773: WHERE pay_plan = p_pay_plan;
3774:
3775: cursor pa_hist_cur (p_r_hist_id number) is
3776: select nvl(action_taken,' ') action_taken

Line 3782: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

3778: where pa_routing_history_id = p_r_hist_id;
3779:
3780: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3781: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';
3782: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3783:
3784: begin
3785: g_proc := 'person_in_pa_req_1noa';
3786: hr_utility.set_location('Entering ' || l_proc,5);