APPS.JA_JAINMCEN_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 73: HR_ALL_ORGANIZATION_UNITS

69: END IF;
70: FOR org_rec IN (SELECT
71: NAME
72: FROM
73: HR_ALL_ORGANIZATION_UNITS
74: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID) LOOP
75: P_ORGANIZATION_NAME := ORG_REC.NAME;
76: END LOOP;
77: FOR loc_rec IN (SELECT

Line 322: HR_ALL_ORGANIZATION_UNITS HRU

318: SELECT
319: HRU.NAME
320: FROM
321: JAI_CMN_INVENTORY_ORGS JHRU,
322: HR_ALL_ORGANIZATION_UNITS HRU
323: WHERE JHRU.ORGANIZATION_ID = ABS(VENDOR_ID)
324: AND JHRU.LOCATION_ID = ABS(VENDOR_SITE_ID)
325: AND HRU.ORGANIZATION_ID = JHRU.ORGANIZATION_ID;
326: CURSOR CUR_GET_VENDOR_NAME(CP_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.VENDOR_ID%TYPE) IS