APPS.GHR_MASS_SEL_NOA dependencies on GHR_PA_ROUTING_HISTORY

Line 60: , ghr_pa_routing_history prh

56: CURSOR csr_action_taken IS
57: SELECT pr.pa_request_id
58: , max (pa_routing_history_id) pa_routing_history_id
59: FROM ghr_pa_requests pr
60: , ghr_pa_routing_history prh
61: WHERE pr.pa_request_id = prh.pa_request_id
62: AND person_id = p_person_id
63: AND first_noa_code = p_first_noa_code
64: AND effective_date = p_effective_date

Line 77: FROM ghr_pa_routing_history

73: WHERE pr.pa_request_id = l_pa_request_id;
74: CURSOR pa_hist_cur
75: (p_r_hist_id IN number) IS
76: SELECT nvl (action_taken, ' ') action_taken
77: FROM ghr_pa_routing_history
78: WHERE pa_routing_history_id = p_r_hist_id;
79: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
80: l_proc varchar2(72) DEFAULT g_package|| '.update_sel_flg';
81: BEGIN

Line 79: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

75: (p_r_hist_id IN number) IS
76: SELECT nvl (action_taken, ' ') action_taken
77: FROM ghr_pa_routing_history
78: WHERE pa_routing_history_id = p_r_hist_id;
79: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
80: l_proc varchar2(72) DEFAULT g_package|| '.update_sel_flg';
81: BEGIN
82: g_proc := 'chk_pa_req_already_exists';
83: hr_utility.set_location ('Entering '|| l_proc, 6);

Line 4381: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

4377: p_full_name per_people_f.full_name%TYPE;
4378: p_employee_number per_people_f.employee_number%TYPE;
4379: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4380: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
4381: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4382: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4383: l_u_prh_object_version_number number;
4384: l_i_pa_routing_history_id number;
4385: l_i_prh_object_version_number number;

Line 4382: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

4378: p_employee_number per_people_f.employee_number%TYPE;
4379: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4380: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
4381: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4382: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4383: l_u_prh_object_version_number number;
4384: l_i_pa_routing_history_id number;
4385: l_i_prh_object_version_number number;
4386: l_object_version_number ghr_pa_requests.object_version_number%TYPE;

Line 4453: FROM ghr_pa_routing_history prh

4449:
4450: CURSOR c_routing_history IS
4451: SELECT prh.pa_routing_history_id
4452: , prh.object_version_number
4453: FROM ghr_pa_routing_history prh
4454: WHERE prh.pa_request_id = l_can_pa_request_id
4455: ORDER BY 1 DESC;
4456:
4457: CURSOR c_req_num IS