APPS.GHR_SF52_API dependencies on GHR_GROUPBOXES

Line 391: FROM ghr_groupboxes gbx

387: WHERE prh.pa_request_id = l_pa_request_id;
388:
389: CURSOR c_groupbox_name IS
390: SELECT gbx.name
391: FROM ghr_groupboxes gbx
392: WHERE gbx.groupbox_id = l_2_groupbox_id;
393:
394: CURSOR c_ovn IS
395: SELECT par.object_version_number

Line 2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;

2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;

Line 2422: FROM ghr_groupboxes gbx

2418: WHERE prh.pa_request_id = p_pa_request_id;
2419:
2420: CURSOR c_groupbox_name IS
2421: SELECT gbx.name
2422: FROM ghr_groupboxes gbx
2423: WHERE gbx.groupbox_id = l_next_groupbox_id;
2424:
2425: CURSOR c_pa_requests IS
2426: SELECT par.noa_family_code,