APPS.GHR_WF_PKG dependencies on HR_ORGANIZATION_UNITS

Line 736: l_to_organization_name hr_organization_units.name%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;
739: l_error_msg varchar2(1200);
740: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;

Line 737: l_from_organization_name hr_organization_units.name%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;
739: l_error_msg varchar2(1200);
740: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;
741: l_creation_date ghr_pa_routing_history.creation_date%TYPE;

Line 772: FROM hr_organization_units

768: WHERE routing_group_id = l_routing_group_id;
769: --
770: cursor csr_org_details is
771: SELECT name
772: FROM hr_organization_units
773: WHERE organization_id = l_to_organization_id ;
774: --
775: cursor csr_get_routing_details is
776: SELECT action_taken from ghr_pa_routing_history

Line 787: FROM hr_organization_units hru,

783: order by 1 asc;
784: --
785: cursor csr_from_org_details is
786: SELECT hru.name
787: FROM hr_organization_units hru,
788: hr_all_positions_f hpf
789: WHERE hpf.position_id = nvl(l_from_position_id,-9999)
790: and nvl(l_effective_date,sysdate)
791: between hpf.effective_start_date