APPS.JA_JAINMCEN_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 311: HR_ORGANIZATION_UNITS HRU

307: HRU.NAME
308: FROM
309: RCV_TRANSACTIONS RCVT,
310: RCV_SHIPMENT_HEADERS RCVSH,
311: HR_ORGANIZATION_UNITS HRU
312: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
313: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
314: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
315: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RECEIPT_SOURCE_CODE

Line 334: V_VENDOR_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;

330: JAI_CMN_RG_23AC_II_TRXS RG23,
331: PO_VENDORS POV
332: WHERE RG23.VENDOR_ID = POV.VENDOR_ID
333: AND RG23.VENDOR_ID = CP_VENDOR_ID;
334: V_VENDOR_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;
335: BEGIN
336: IF VENDOR_ID IS NULL THEN
337: OPEN INT_ORDER_CUR(RECEIPT_ID,'INTERNAL ORDER');
338: FETCH INT_ORDER_CUR