63: ,10)))
64: ,1
65: ,255)
66: FROM
67: HR_ALL_ORGANIZATION_UNITS A,
68: HR_LOCATIONS B
69: WHERE A.ORGANIZATION_ID = B.INVENTORY_ORGANIZATION_ID
70: AND A.ORGANIZATION_ID = ABS(P_CUSTOMER_ID)
71: AND B.LOCATION_ID = ABS(P_SHIP_TO_SITE_ID);
246: ,10)))
247: ,1
248: ,255)
249: FROM
250: HR_ALL_ORGANIZATION_UNITS A,
251: HR_LOCATIONS B
252: WHERE A.ORGANIZATION_ID = B.INVENTORY_ORGANIZATION_ID
253: AND A.ORGANIZATION_ID = ABS(P_CUSTOMER_ID)
254: AND B.LOCATION_ID = ABS(P_SHIP_TO_SITE_ID);
335: CURSOR FOR_NAME(ORG_ID IN NUMBER) IS
336: SELECT
337: NAME
338: FROM
339: HR_ALL_ORGANIZATION_UNITS
340: WHERE ORGANIZATION_ID = ORG_ID;
341: V_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
342: BEGIN
343: OPEN FOR_NAME(P_ORGANIZATION_ID);
337: NAME
338: FROM
339: HR_ALL_ORGANIZATION_UNITS
340: WHERE ORGANIZATION_ID = ORG_ID;
341: V_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
342: BEGIN
343: OPEN FOR_NAME(P_ORGANIZATION_ID);
344: FETCH FOR_NAME
345: INTO V_NAME;
487: ,10)))
488: ,1
489: ,255)
490: FROM
491: HR_ALL_ORGANIZATION_UNITS A,
492: HR_LOCATIONS B
493: WHERE A.ORGANIZATION_ID = B.INVENTORY_ORGANIZATION_ID
494: AND A.ORGANIZATION_ID = ABS(P_VENDOR_ID)
495: AND B.LOCATION_ID = ABS(P_VENDOR_SITE_ID);