726: /* MOAC_SQL_CHANGE */
727: NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
728: INTO l_cust_trx_type_id
729: FROM ra_cust_trx_types_all cust_type,
730: ra_customer_trx cust_trx
731: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
732: AND cust_type.org_id = cust_trx.org_id
733: AND cust_trx.customer_trx_id = l_commitment_id;
734: EXCEPTION
892: /* MOAC_SQL_CHANGE */
893: NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
894: INTO l_cust_trx_type_id
895: FROM ra_cust_trx_types_all cust_type,
896: ra_customer_trx cust_trx
897: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
898: AND cust_type.org_id = cust_trx.org_id
899: AND cust_trx.customer_trx_id = l_commitment_id;
900: EXCEPTION