APPS.GHR_MSL_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 3688: from ghr_pa_requests pr, ghr_pa_routing_history prh

3684: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3685:
3686: cursor csr_action_taken is
3687: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3688: from ghr_pa_requests pr, ghr_pa_routing_history prh
3689: where pr.pa_request_id = prh.pa_request_id
3690: and person_id = p_person_id
3691: and first_noa_code = p_first_noa_code
3692: and effective_date = p_effective_date

Line 3707: from ghr_pa_requests pr, ghr_pa_routing_history prh

3703: where pr.pa_request_id = l_pa_request_id;
3704:
3705: cursor csr_action_taken_fw is
3706: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3707: from ghr_pa_requests pr, ghr_pa_routing_history prh
3708: where pr.pa_request_id = prh.pa_request_id
3709: and person_id = p_person_id
3710: and first_noa_code = p_first_noa_code
3711: and effective_date = p_effective_date

Line 3722: from ghr_pa_routing_history

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

Line 3725: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

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

Line 3807: from ghr_pa_requests pr, ghr_pa_routing_history prh

3803: return boolean is
3804: --
3805: cursor csr_action_taken is
3806: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3807: from ghr_pa_requests pr, ghr_pa_routing_history prh
3808: where pr.pa_request_id = prh.pa_request_id
3809: and nvl(person_id,0) = p_person_id
3810: and nvl(second_noa_code,0) = p_second_noa_code
3811: and nvl(effective_date,trunc(sysdate)) >= (p_effective_date-p_days)

Line 3819: from ghr_pa_routing_history

3815: group by pr.pa_request_id;
3816:
3817: cursor pa_hist_cur (p_r_hist_id number) is
3818: select nvl(action_taken,' ') action_taken
3819: from ghr_pa_routing_history
3820: where pa_routing_history_id = p_r_hist_id;
3821:
3822: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3823: l_proc varchar2(72) := g_package || '.person_in_pa_req_2noa';

Line 3822: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

3818: select nvl(action_taken,' ') action_taken
3819: from ghr_pa_routing_history
3820: where pa_routing_history_id = p_r_hist_id;
3821:
3822: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3823: l_proc varchar2(72) := g_package || '.person_in_pa_req_2noa';
3824: begin
3825: g_proc := 'person_in_pa_req_2noa';
3826: hr_utility.set_location('Entering ' || l_proc,5);