DBA Data[Home] [Help]

APPS.JA_JAIN23P2_XMLP_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 412: JAI_CMN_VENDOR_SITES

408: CURSOR C_FETCH_EC_CODE IS
409: SELECT
410: EC_CODE
411: FROM
412: JAI_CMN_VENDOR_SITES
413: WHERE VENDOR_ID = VENDOR_ID
414: AND VENDOR_SITE_ID = VENDOR_SITE_ID;
415: CURSOR C_FETCH_EC_CODE_FOR_ISO IS
416: SELECT

Line 435: V_EC_CODE_SUP JAI_CMN_VENDOR_SITES.EC_CODE%TYPE;

431: AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE
432: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
433: AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE
434: AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;
435: V_EC_CODE_SUP JAI_CMN_VENDOR_SITES.EC_CODE%TYPE;
436: BEGIN
437: IF (NVL(CR_BASIC_ED
438: ,0) + NVL(CR_ADDITIONAL_ED
439: ,0) + NVL(CR_ADDITIONAL_CVD