APPS.GHR_WF_PKG dependencies on GHR_ROUTING_GROUPS

Line 733: l_routing_group_name ghr_routing_groups.name%TYPE;

729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
733: l_routing_group_name ghr_routing_groups.name%TYPE;
734: l_description ghr_routing_groups.description%TYPE;
735: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
736: l_to_organization_name hr_organization_units.name%TYPE;
737: l_from_organization_name hr_organization_units.name%TYPE;

Line 734: l_description ghr_routing_groups.description%TYPE;

730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
733: l_routing_group_name ghr_routing_groups.name%TYPE;
734: l_description ghr_routing_groups.description%TYPE;
735: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
736: l_to_organization_name hr_organization_units.name%TYPE;
737: l_from_organization_name hr_organization_units.name%TYPE;
738: l_noa_fam_desc ghr_families.name%TYPE;

Line 767: FROM ghr_routing_groups

763: WHERE noa_family_code = l_noa_family_code;
764: --
765: cursor csr_routing_groups is
766: SELECT name, description
767: FROM ghr_routing_groups
768: WHERE routing_group_id = l_routing_group_id;
769: --
770: cursor csr_org_details is
771: SELECT name

Line 1315: l_routing_group_id ghr_routing_groups.routing_group_id%type;

1311: --
1312: l_forward_to_name varchar2(30);
1313: l_user_name varchar2(30);
1314: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1315: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1316: l_effective_date ghr_pa_requests.effective_date%type;
1317: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1318: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1319: l_noa_family_code ghr_pa_requests.noa_family_code%type;