DBA Data[Home] [Help]

APPS.WSH_WSHRDBDR_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 260: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;

256: END;
257: END IF;
258: IF P_ORGANIZATION_ID IS NOT NULL THEN
259: DECLARE
260: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;
261: BEGIN
262: SELECT
263: NAME
264: INTO WAREHOUSE_NAME

Line 266: HR_ORGANIZATION_UNITS

262: SELECT
263: NAME
264: INTO WAREHOUSE_NAME
265: FROM
266: HR_ORGANIZATION_UNITS
267: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
268: RP_WAREHOUSE := WAREHOUSE_NAME;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN