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
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