APPS.ZX_TCM_PTP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 592: FROM hr_all_organization_units

588:
589: -- BUG 8568734
590: CURSOR get_ou_name_csr IS
591: SELECT name
592: FROM hr_all_organization_units
593: WHERE organization_id = p_org_id;
594:
595: CURSOR get_le_name_csr IS
596: SELECT name

Line 853: FROM hr_all_organization_units

849: p_return_status OUT NOCOPY VARCHAR2)
850: IS
851: CURSOR c_get_location_id IS
852: SELECT location_id, name
853: FROM hr_all_organization_units
854: WHERE organization_id = p_org_id;
855:
856: -- Logging Infra
857: l_procedure_name CONSTANT VARCHAR2(30) := '.GET_LOCATION_ID';