eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GHR_WF_PKG dependencies on GHR_ROUTING_GROUPS

Line 737: l_routing_group_name ghr_routing_groups.name%TYPE;

733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
736: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
737: l_routing_group_name ghr_routing_groups.name%TYPE;
738: l_description ghr_routing_groups.description%TYPE;
739: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
740: l_to_organization_name hr_organization_units.name%TYPE;
741: l_from_organization_name hr_organization_units.name%TYPE;

Line 738: l_description ghr_routing_groups.description%TYPE;

734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
736: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
737: l_routing_group_name ghr_routing_groups.name%TYPE;
738: l_description ghr_routing_groups.description%TYPE;
739: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
740: l_to_organization_name hr_organization_units.name%TYPE;
741: l_from_organization_name hr_organization_units.name%TYPE;
742: l_noa_fam_desc ghr_families.name%TYPE;

Line 771: FROM ghr_routing_groups

767: WHERE noa_family_code = l_noa_family_code;
768: --
769: cursor csr_routing_groups is
770: SELECT name, description
771: FROM ghr_routing_groups
772: WHERE routing_group_id = l_routing_group_id;
773: --
774: cursor csr_org_details is
775: SELECT name

Line 1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;

1333: --BUG #13655849 increased the size of user_name
1334: l_forward_to_name ghr_pa_routing_history.user_name%TYPE;
1335: l_user_name ghr_pa_routing_history.user_name%TYPE;
1336: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1338: l_effective_date ghr_pa_requests.effective_date%type;
1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1340: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1341: l_noa_family_code ghr_pa_requests.noa_family_code%type;