DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 5567: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

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:

Line 10465: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

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: