APPS.GHR_MLC_PKG dependencies on GHR_PAY_PLANS

Line 3181: from ghr_pay_plans

3177: FUNCTION GET_PAY_PLAN_NAME (PP IN VARCHAR2) RETURN VARCHAR2 IS
3178:
3179: CURSOR CUR_PP IS
3180: select pay_plan,description
3181: from ghr_pay_plans
3182: WHERE PAY_PLAN = PP;
3183: l_pp_desc varchar2(150);
3184: BEGIN
3185: FOR PP_REC IN CUR_PP

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

3452: return boolean is
3453:
3454: l_proc varchar2(72) := g_package || '.check_eligibility';
3455:
3456: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
3457: IS
3458: SELECT 1
3459: FROM ghr_pay_plans
3460: WHERE equivalent_pay_plan ='ES'

Line 3459: FROM ghr_pay_plans

3455:
3456: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
3457: IS
3458: SELECT 1
3459: FROM ghr_pay_plans
3460: WHERE equivalent_pay_plan ='ES'
3461: AND pay_plan=p_pay_plan;
3462:
3463: BEGIN

Line 3552: FROM ghr_pay_plans

3548: group by pr.pa_request_id;
3549:
3550: cursor csr_eq_pay_plan is
3551: SELECT equivalent_pay_plan
3552: FROM ghr_pay_plans
3553: WHERE pay_plan = p_pay_plan;
3554:
3555: cursor pa_hist_cur (p_r_hist_id number) is
3556: select nvl(action_taken,' ') action_taken

Line 3562: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

3558: where pa_routing_history_id = p_r_hist_id;
3559:
3560: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3561: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';
3562: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3563:
3564: begin
3565: g_proc := 'person_in_pa_req_1noa';
3566: hr_utility.set_location('Entering ' || l_proc,5);

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

3628: return boolean is
3629:
3630: l_proc varchar2(72) := g_package || '.check_eligibility';
3631:
3632: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
3633: IS
3634: SELECT 1
3635: FROM ghr_pay_plans
3636: WHERE equivalent_pay_plan ='ES'

Line 3635: FROM ghr_pay_plans

3631:
3632: CURSOR cur_equiv_ES_pay_plan(p_pay_plan ghr_pay_plans.pay_plan%TYPE)
3633: IS
3634: SELECT 1
3635: FROM ghr_pay_plans
3636: WHERE equivalent_pay_plan ='ES'
3637: AND pay_plan=p_pay_plan;
3638:
3639: BEGIN

Line 3726: FROM ghr_pay_plans

3722: group by pr.pa_request_id;
3723:
3724: cursor csr_eq_pay_plan is
3725: SELECT equivalent_pay_plan
3726: FROM ghr_pay_plans
3727: WHERE pay_plan = p_pay_plan;
3728:
3729: cursor pa_hist_cur (p_r_hist_id number) is
3730: select nvl(action_taken,' ') action_taken

Line 3736: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

3732: where pa_routing_history_id = p_r_hist_id;
3733:
3734: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3735: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';
3736: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3737:
3738: begin
3739: g_proc := 'person_in_pa_req_1noa';
3740: hr_utility.set_location('Entering ' || l_proc,5);