APPS.GHR_MLC_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 3571: from ghr_pa_requests pr, ghr_pa_routing_history prh

3567: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3568:
3569: cursor csr_action_taken is
3570: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3571: from ghr_pa_requests pr, ghr_pa_routing_history prh
3572: where pr.pa_request_id = prh.pa_request_id
3573: and person_id = p_person_id
3574: and first_noa_code = p_first_noa_code
3575: and effective_date = p_effective_date

Line 3588: from ghr_pa_requests pr, ghr_pa_routing_history prh

3584: where pr.pa_request_id = l_pa_request_id;
3585:
3586: cursor csr_action_taken_fw is
3587: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3588: from ghr_pa_requests pr, ghr_pa_routing_history prh
3589: where pr.pa_request_id = prh.pa_request_id
3590: and person_id = p_person_id
3591: and first_noa_code = p_first_noa_code
3592: and effective_date = p_effective_date

Line 3603: from ghr_pa_routing_history

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
3603: from ghr_pa_routing_history
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';

Line 3606: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

3602: select nvl(action_taken,' ') action_taken
3603: from ghr_pa_routing_history
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

Line 3747: from ghr_pa_requests pr, ghr_pa_routing_history prh

3743: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3744:
3745: cursor csr_action_taken is
3746: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3747: from ghr_pa_requests pr, ghr_pa_routing_history prh
3748: where pr.pa_request_id = prh.pa_request_id
3749: and person_id = p_person_id
3750: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3751: and effective_date = p_effective_date

Line 3762: from ghr_pa_requests pr, ghr_pa_routing_history prh

3758: where pr.pa_request_id = l_pa_request_id;
3759:
3760: cursor csr_action_taken_fw is
3761: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3762: from ghr_pa_requests pr, ghr_pa_routing_history prh
3763: where pr.pa_request_id = prh.pa_request_id
3764: and person_id = p_person_id
3765: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3766: and effective_date = p_effective_date

Line 3777: from ghr_pa_routing_history

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
3777: from ghr_pa_routing_history
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';

Line 3780: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

3776: select nvl(action_taken,' ') action_taken
3777: from ghr_pa_routing_history
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

Line 5515: from ghr_pa_requests pr, ghr_pa_routing_history prh

5511: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
5512:
5513: cursor csr_action_taken is
5514: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
5515: from ghr_pa_requests pr, ghr_pa_routing_history prh
5516: where pr.pa_request_id = prh.pa_request_id
5517: and person_id = p_person_id
5518: and first_noa_code = p_first_noa_code
5519: and effective_date = p_effective_date

Line 5531: from ghr_pa_routing_history

5527:
5528:
5529: cursor pa_hist_cur (p_r_hist_id number) is
5530: select nvl(action_taken,' ') action_taken
5531: from ghr_pa_routing_history
5532: where pa_routing_history_id = p_r_hist_id;
5533:
5534: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
5535: l_proc varchar2(72) := g_package || '.chk_pa_req_already_exists';

Line 5534: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

5530: select nvl(action_taken,' ') action_taken
5531: from ghr_pa_routing_history
5532: where pa_routing_history_id = p_r_hist_id;
5533:
5534: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
5535: l_proc varchar2(72) := g_package || '.chk_pa_req_already_exists';
5536: l_sel_flg varchar2(2);
5537:
5538: begin