APPS.GHR_SF52_API dependencies on GHR_GROUPBOXES

Line 264: l_forward_to_name ghr_groupboxes.name%TYPE;

260: l_user_name_emp_first_name per_people_f.first_name%TYPE;
261: l_user_name_emp_last_name per_people_f.last_name%TYPE;
262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
264: l_forward_to_name ghr_groupboxes.name%TYPE;
265: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
266: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
267: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
268: l_temp number(15);

Line 385: FROM ghr_groupboxes gbx

381: WHERE prh.pa_request_id = l_pa_request_id;
382:
383: CURSOR c_groupbox_name IS
384: SELECT gbx.name
385: FROM ghr_groupboxes gbx
386: WHERE gbx.groupbox_id = l_2_groupbox_id;
387:
388: CURSOR c_ovn IS
389: SELECT par.object_version_number

Line 2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;

2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2187: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2189: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;

Line 2343: FROM ghr_groupboxes gbx

2339: WHERE prh.pa_request_id = p_pa_request_id;
2340:
2341: CURSOR c_groupbox_name IS
2342: SELECT gbx.name
2343: FROM ghr_groupboxes gbx
2344: WHERE gbx.groupbox_id = l_next_groupbox_id;
2345:
2346: CURSOR c_pa_requests IS
2347: SELECT par.noa_family_code,