APPS.GHR_WF_PD_PKG dependencies on GHR_ROUTING_GROUPS

Line 452: l_description ghr_routing_groups.description%TYPE;

448: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
449: l_grade_level ghr_pd_classifications.grade_level%TYPE;
450: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
451: l_full_name per_people_f.full_name%TYPE;
452: l_description ghr_routing_groups.description%TYPE;
453: l_name varchar2(240);
454: l_official_title ghr_pd_classifications.official_title%TYPE;
455: --
456: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;

Line 463: l_routing_group_name ghr_routing_groups.name%TYPE;

459: l_date_received ghr_pd_routing_history.date_notification_sent%TYPE;
460: l_date_notification_sent ghr_pd_routing_history.date_notification_sent%TYPE;
461: --
462: l_routing_group_id ghr_position_descriptions.routing_group_id%TYPE;
463: l_routing_group_name ghr_routing_groups.name%TYPE;
464: l_count integer;
465: --
466: --
467: cursor csr_pd_details is

Line 486: FROM ghr_routing_groups

482: --
483: --
484: cursor csr_rgps is
485: SELECT name, description
486: FROM ghr_routing_groups
487: WHERE routing_group_id = l_routing_group_id;
488: --
489: cursor csr_get_routing_details is
490: SELECT action_taken, date_notification_sent from ghr_pd_routing_history