APPS.GHR_MSL_PKG dependencies on GHR_PAY_PLANS

Line 365: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)

361:
362: --
363: -- GPPA Update 46
364: --
365: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
366: IS
367: select EQUIVALENT_PAY_PLAN
368: from ghr_pay_plans
369: where pay_plan = c_pay_plan;

Line 368: from ghr_pay_plans

364: --
365: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
366: IS
367: select EQUIVALENT_PAY_PLAN
368: from ghr_pay_plans
369: where pay_plan = c_pay_plan;
370:
371: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
372:

Line 371: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;

367: select EQUIVALENT_PAY_PLAN
368: from ghr_pay_plans
369: where pay_plan = c_pay_plan;
370:
371: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
372:
373: --
374: --
375:

Line 2601: from ghr_pay_plans

2597: FUNCTION GET_PAY_PLAN_NAME (PP IN VARCHAR2) RETURN VARCHAR2 IS
2598:
2599: CURSOR CUR_PP IS
2600: select pay_plan,description
2601: from ghr_pay_plans
2602: WHERE PAY_PLAN = PP;
2603: l_pp_desc varchar2(150);
2604: BEGIN
2605: FOR PP_REC IN CUR_PP

Line 3753: FROM ghr_pay_plans

3749: group by pr.pa_request_id;
3750:
3751: cursor csr_eq_pay_plan is
3752: SELECT equivalent_pay_plan
3753: FROM ghr_pay_plans
3754: WHERE pay_plan = p_pay_plan;
3755:
3756: cursor pa_hist_cur (p_r_hist_id number) is
3757: select nvl(action_taken,' ') action_taken

Line 3763: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

3759: where pa_routing_history_id = p_r_hist_id;
3760:
3761: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3762: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';
3763: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3764:
3765: begin
3766: g_proc := 'person_in_pa_req_1noa';
3767: hr_utility.set_location('Entering ' || l_proc,5);

Line 5269: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)

5265:
5266: --
5267: -- GPPA Update 46
5268: --
5269: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
5270: IS
5271: select EQUIVALENT_PAY_PLAN
5272: from ghr_pay_plans
5273: where pay_plan = c_pay_plan;

Line 5272: from ghr_pay_plans

5268: --
5269: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
5270: IS
5271: select EQUIVALENT_PAY_PLAN
5272: from ghr_pay_plans
5273: where pay_plan = c_pay_plan;
5274:
5275: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5276:

Line 5275: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;

5271: select EQUIVALENT_PAY_PLAN
5272: from ghr_pay_plans
5273: where pay_plan = c_pay_plan;
5274:
5275: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5276:
5277: --
5278: --
5279: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE

Line 7401: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)

7397:
7398: --
7399: -- GPPA Update 46
7400: --
7401: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
7402: IS
7403: select EQUIVALENT_PAY_PLAN
7404: from ghr_pay_plans
7405: where pay_plan = c_pay_plan;

Line 7404: from ghr_pay_plans

7400: --
7401: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
7402: IS
7403: select EQUIVALENT_PAY_PLAN
7404: from ghr_pay_plans
7405: where pay_plan = c_pay_plan;
7406:
7407: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
7408: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;

Line 7407: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;

7403: select EQUIVALENT_PAY_PLAN
7404: from ghr_pay_plans
7405: where pay_plan = c_pay_plan;
7406:
7407: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
7408: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
7409:
7410:
7411: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE