APPS.GHR_WF_PKG dependencies on HR_ORGANIZATION_UNITS

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

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

Line 776: FROM hr_organization_units

772: WHERE routing_group_id = l_routing_group_id;
773: --
774: cursor csr_org_details is
775: SELECT name
776: FROM hr_organization_units
777: WHERE organization_id = l_to_organization_id ;
778: --
779: cursor csr_get_routing_details is
780: SELECT action_taken from ghr_pa_routing_history

Line 791: FROM hr_organization_units hru,

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