APPS.JA_JAIN23D_XMLP_PKG dependencies on HR_LOCATIONS

Line 68: HR_LOCATIONS B

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);
72: CURSOR C_RCV_DTLS(P_REGISTER_ID IN NUMBER) IS

Line 251: HR_LOCATIONS B

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);
255: CURSOR C_CUST_VEND_IDS(P_REGISTER_ID IN NUMBER) IS

Line 355: HR_LOCATIONS

351: CURSOR FOR_LOC(LOC_ID IN NUMBER) IS
352: SELECT
353: DESCRIPTION
354: FROM
355: HR_LOCATIONS
356: WHERE LOCATION_ID = LOC_ID;
357: V_DESCRIPTION VARCHAR2(100);
358: BEGIN
359: OPEN FOR_LOC(P_LOCATION_ID);

Line 492: HR_LOCATIONS B

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);
496: CURSOR C_VEND_ADDRESS(P_VENDOR_ID IN NUMBER,P_VENDOR_SITE_ID IN NUMBER) IS