APPS.ZX_TCM_PTP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 736: FROM hr_all_organization_units

732: p_return_status OUT NOCOPY VARCHAR2)
733: IS
734: CURSOR c_get_location_id IS
735: SELECT location_id
736: FROM hr_all_organization_units
737: WHERE organization_id = p_org_id;
738:
739: -- Logging Infra
740: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_LOCATION_ID';