DBA Data[Home] [Help]

APPS.WSH_WSHRDBDR_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 282: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;

278: END;
279: END IF;
280: IF P_ORGANIZATION_ID IS NOT NULL THEN
281: DECLARE
282: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;
283: BEGIN
284: SELECT
285: NAME
286: INTO WAREHOUSE_NAME

Line 288: HR_ORGANIZATION_UNITS

284: SELECT
285: NAME
286: INTO WAREHOUSE_NAME
287: FROM
288: HR_ORGANIZATION_UNITS
289: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
290: RP_WAREHOUSE := WAREHOUSE_NAME;
291: EXCEPTION
292: WHEN NO_DATA_FOUND THEN