DBA Data[Home] [Help]

APPS.JA_JAIN23P2_XMLP_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 477: JAI_CMN_CUS_ADDRESSES

473: CURSOR C_ECCODE_CUSTOMER IS
474: SELECT
475: EC_CODE
476: FROM
477: JAI_CMN_CUS_ADDRESSES
478: WHERE CUSTOMER_ID = CUSTOMER_ID_1
479: AND ADDRESS_ID = CUSTOMER_SITE_ID;
480: V_EC_CODE_CUS JAI_CMN_CUS_ADDRESSES.EC_CODE%TYPE;
481: BEGIN

Line 480: V_EC_CODE_CUS JAI_CMN_CUS_ADDRESSES.EC_CODE%TYPE;

476: FROM
477: JAI_CMN_CUS_ADDRESSES
478: WHERE CUSTOMER_ID = CUSTOMER_ID_1
479: AND ADDRESS_ID = CUSTOMER_SITE_ID;
480: V_EC_CODE_CUS JAI_CMN_CUS_ADDRESSES.EC_CODE%TYPE;
481: BEGIN
482: IF (NVL(DR_BASIC_ED
483: ,0) + NVL(DR_ADDITIONAL_ED
484: ,0) + NVL(DR_OTHER_ED