APPS.JMF_GTA_REPORTS_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 249: , Ra_Cust_Trx_Types_all ctt

245: L_Ret_Xmlelement
246: FROM
247: Ra_Customer_Trx_all ract
248: , ra_batches_all bat
249: , Ra_Cust_Trx_Types_all ctt
250: , Hz_Cust_Accounts RAC_BILL
251: , Hz_Parties RAC_BILL_PARTY
252:
253: WHERE Customer_Trx_Id = P_Ar_Trx_Header_Id

Line 283: , Ra_Cust_Trx_Types_all ctt

279: L_Ret_Xmlelement
280: FROM
281: Ra_Customer_Trx_all ract
282: , ra_batches_all bat
283: , Ra_Cust_Trx_Types_all ctt
284: , Hz_Cust_Accounts RAC_BILL
285: , Hz_Parties RAC_BILL_PARTY
286:
287: WHERE Customer_Trx_Id = P_Ar_Trx_Header_Id

Line 3664: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;

3660: l_gta_batch_num_from jmf_gta_trx_headers_all.gta_batch_number%TYPE
3661: :=p_gta_batch_num_from;
3662: l_gta_batch_num_to jmf_gta_trx_headers_all.gta_batch_number%TYPE
3663: :=p_gta_batch_num_to;
3664: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;
3665: l_cust_num_from hz_cust_accounts.account_number%TYPE
3666: :=p_cust_num_from;
3667: l_cust_num_to hz_cust_accounts.account_number%TYPE
3668: :=p_cust_num_to;

Line 3743: ra_cust_trx_types_all

3739: CURSOR c_ar_transaction_type IS
3740: SELECT
3741: name
3742: FROM
3743: ra_cust_trx_types_all
3744: WHERE cust_trx_type_id=p_ar_transaction_type;
3745:
3746: CURSOR c_customer_name IS
3747: SELECT