APPS.GHR_MSL_PKG dependencies on GHR_PAY_PLANS

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

357:
358: --
359: -- GPPA Update 46
360: --
361: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
362: IS
363: select EQUIVALENT_PAY_PLAN
364: from ghr_pay_plans
365: where pay_plan = c_pay_plan;

Line 364: from ghr_pay_plans

360: --
361: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
362: IS
363: select EQUIVALENT_PAY_PLAN
364: from ghr_pay_plans
365: where pay_plan = c_pay_plan;
366:
367: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
368:

Line 367: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;

363: select EQUIVALENT_PAY_PLAN
364: from ghr_pay_plans
365: where pay_plan = c_pay_plan;
366:
367: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
368:
369: --
370: --
371:

Line 2573: from ghr_pay_plans

2569: FUNCTION GET_PAY_PLAN_NAME (PP IN VARCHAR2) RETURN VARCHAR2 IS
2570:
2571: CURSOR CUR_PP IS
2572: select pay_plan,description
2573: from ghr_pay_plans
2574: WHERE PAY_PLAN = PP;
2575: l_pp_desc varchar2(150);
2576: BEGIN
2577: FOR PP_REC IN CUR_PP

Line 3717: FROM ghr_pay_plans

3713: group by pr.pa_request_id;
3714:
3715: cursor csr_eq_pay_plan is
3716: SELECT equivalent_pay_plan
3717: FROM ghr_pay_plans
3718: WHERE pay_plan = p_pay_plan;
3719:
3720: cursor pa_hist_cur (p_r_hist_id number) is
3721: select nvl(action_taken,' ') action_taken

Line 3727: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

3723: where pa_routing_history_id = p_r_hist_id;
3724:
3725: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3726: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';
3727: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3728:
3729: begin
3730: g_proc := 'person_in_pa_req_1noa';
3731: hr_utility.set_location('Entering ' || l_proc,5);

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

5203:
5204: --
5205: -- GPPA Update 46
5206: --
5207: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
5208: IS
5209: select EQUIVALENT_PAY_PLAN
5210: from ghr_pay_plans
5211: where pay_plan = c_pay_plan;

Line 5210: from ghr_pay_plans

5206: --
5207: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
5208: IS
5209: select EQUIVALENT_PAY_PLAN
5210: from ghr_pay_plans
5211: where pay_plan = c_pay_plan;
5212:
5213: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5214:

Line 5213: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;

5209: select EQUIVALENT_PAY_PLAN
5210: from ghr_pay_plans
5211: where pay_plan = c_pay_plan;
5212:
5213: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5214:
5215: --
5216: --
5217: PROCEDURE msl_perc_process(p_assignment_id per_assignments_f.assignment_id%TYPE

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

7251:
7252: --
7253: -- GPPA Update 46
7254: --
7255: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
7256: IS
7257: select EQUIVALENT_PAY_PLAN
7258: from ghr_pay_plans
7259: where pay_plan = c_pay_plan;

Line 7258: from ghr_pay_plans

7254: --
7255: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
7256: IS
7257: select EQUIVALENT_PAY_PLAN
7258: from ghr_pay_plans
7259: where pay_plan = c_pay_plan;
7260:
7261: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
7262: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;

Line 7261: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;

7257: select EQUIVALENT_PAY_PLAN
7258: from ghr_pay_plans
7259: where pay_plan = c_pay_plan;
7260:
7261: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
7262: l_ses_basic_pay ghr_mass_actions_preview.to_basic_pay%type;
7263:
7264:
7265: PROCEDURE msl_ses_process(p_assignment_id per_assignments_f.assignment_id%TYPE