APPS.ARRX_BSS dependencies on RA_CUST_TRX_TYPES

Line 43: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;

39: v_CursorID_app INTEGER;
40: v_Dummy_app INTEGER;
41:
42: -- Declare the variables which will hold the results of the SELECT statements
43: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;
44: v_transaction_type_id RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE;
45: v_status AR_LOOKUPS.meaning%TYPE;
46: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
47: v_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

Line 44: v_transaction_type_id RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE;

40: v_Dummy_app INTEGER;
41:
42: -- Declare the variables which will hold the results of the SELECT statements
43: v_transaction_type RA_CUST_TRX_TYPES.name%TYPE;
44: v_transaction_type_id RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE;
45: v_status AR_LOOKUPS.meaning%TYPE;
46: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
47: v_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
48: v_balance_due NUMBER;

Line 110: FROM ra_cust_trx_types_all ctt

106: ,ctt.name transaction_type
107: ,ctt.cust_trx_type_id
108: ,rah.status
109: ,arl.meaning
110: FROM ra_cust_trx_types_all ctt
111: ,ra_customer_trx_all trx
112: ,ar_transaction_history_all rah
113: ,ar_lookups arl
114: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id

Line 137: FROM ra_cust_trx_types_all ctt

133: l_amount := 'SELECT nvl(ps.amount_due_remaining,0)
134: ,nvl(ps.acctd_amount_due_remaining,0)
135: ,trx.customer_trx_id
136: ,ps.exchange_rate
137: FROM ra_cust_trx_types_all ctt
138: ,ra_customer_trx_all trx
139: ,ar_transaction_history_all rah
140: ,ar_payment_schedules_all ps
141: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id