APPS.GHR_WF_PD_PKG dependencies on GHR_GROUPBOXES

Line 199: l_groupbox_name ghr_groupboxes.name%TYPE;

195: --
196: l_user_name ghr_pd_routing_history.user_name%TYPE;
197: l_from_name VARCHAR2(500);
198: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
199: l_groupbox_name ghr_groupboxes.name%TYPE;
200: l_category ghr_position_descriptions.category%TYPE;
201: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
202: l_official_title ghr_pd_classifications.official_title%TYPE;
203: l_grade_level ghr_pd_classifications.grade_level%TYPE;

Line 358: l_groupbox_name ghr_groupboxes.name%TYPE;

354: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
355: l_user_name ghr_pd_routing_history.user_name%TYPE;
356: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
357: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
358: l_groupbox_name ghr_groupboxes.name%TYPE;
359: --
360: cursor csr_pd_routing_history is
361: SELECT max(pd_routing_history_id)
362: FROM ghr_pd_routing_history

Line 371: FROM GHR_GROUPBOXES

367: FROM ghr_pd_routing_history
368: WHERE pd_routing_history_id = l_pd_routing_history_id;
369: cursor csr_groupbox_details is
370: SELECT name
371: FROM GHR_GROUPBOXES
372: WHERE GROUPBOX_ID = l_groupbox_id;
373: --
374: --
375: begin