5563: WHERE REGIME_CODE = CP_REGIME_CODE;
5564:
5565: Cursor transaction_type_cur IS
5566: Select a.type
5567: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
5568: Where a.cust_trx_type_id = b.cust_trx_type_id
5569: And b.customer_trx_id = v_customer_trx_id
5570: And NVL(a.org_id, 0) = NVL(b.org_id, 0);
5571:
10461:
10462: Cursor transaction_type_cur(cn_customer_trx_id number)
10463: IS
10464: Select a.type
10465: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
10466: Where a.cust_trx_type_id = b.cust_trx_type_id
10467: And b.customer_trx_id = cn_customer_trx_id
10468: And NVL(a.org_id, 0) = NVL(b.org_id, 0);
10469: