APPS.GHR_MSL_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 3724: from ghr_pa_requests pr, ghr_pa_routing_history prh

3720: l_employee_number per_people_f.employee_number%type;
3721:
3722: cursor csr_action_taken is
3723: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3724: from ghr_pa_requests pr, ghr_pa_routing_history prh
3725: where pr.pa_request_id = prh.pa_request_id
3726: and person_id = p_person_id
3727: and first_noa_code = p_first_noa_code
3728: and effective_date = p_effective_date

Line 3743: from ghr_pa_requests pr, ghr_pa_routing_history prh

3739: where pr.pa_request_id = l_pa_request_id;
3740:
3741: cursor csr_action_taken_fw is
3742: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3743: from ghr_pa_requests pr, ghr_pa_routing_history prh
3744: where pr.pa_request_id = prh.pa_request_id
3745: and person_id = p_person_id
3746: and first_noa_code = p_first_noa_code
3747: and effective_date = p_effective_date

Line 3758: from ghr_pa_routing_history

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

Line 3761: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

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

Line 3859: from ghr_pa_requests pr, ghr_pa_routing_history prh

3855: return boolean is
3856: --
3857: cursor csr_action_taken is
3858: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3859: from ghr_pa_requests pr, ghr_pa_routing_history prh
3860: where pr.pa_request_id = prh.pa_request_id
3861: and nvl(person_id,0) = p_person_id
3862: and nvl(second_noa_code,0) = p_second_noa_code
3863: and nvl(effective_date,trunc(sysdate)) >= (p_effective_date-p_days)

Line 3871: from ghr_pa_routing_history

3867: group by pr.pa_request_id;
3868:
3869: cursor pa_hist_cur (p_r_hist_id number) is
3870: select nvl(action_taken,' ') action_taken
3871: from ghr_pa_routing_history
3872: where pa_routing_history_id = p_r_hist_id;
3873:
3874: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3875: l_proc varchar2(72) := g_package || '.person_in_pa_req_2noa';

Line 3874: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

3870: select nvl(action_taken,' ') action_taken
3871: from ghr_pa_routing_history
3872: where pa_routing_history_id = p_r_hist_id;
3873:
3874: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3875: l_proc varchar2(72) := g_package || '.person_in_pa_req_2noa';
3876: begin
3877: g_proc := 'person_in_pa_req_2noa';
3878: hr_utility.set_location('Entering ' || l_proc,5);