APPS.AR_GTA_REPORTS_PKG dependencies on RA_CUST_TRX_TYPES

Line 279: , Ra_Cust_Trx_Types_all ctt

275: Ra_Customer_Trx_all ract
276: --yao zhang modified for bug8766075
277: -- , ra_batches_all bat
278: ,RA_BATCH_SOURCES_ALL bas
279: , Ra_Cust_Trx_Types_all ctt
280: , Hz_Cust_Accounts RAC_BILL
281: , Hz_Parties RAC_BILL_PARTY
282: -- added by Allen Yang 24-Sep-2009 for bug 8920326
283: ----------------------------------------------------

Line 334: , Ra_Cust_Trx_Types_all ctt

330: Ra_Customer_Trx_all ract
331: --yao zhang modified for bug8766075
332: -- , ra_batches_all bat
333: ,RA_BATCH_SOURCES_ALL bas
334: , Ra_Cust_Trx_Types_all ctt
335: , Hz_Cust_Accounts RAC_BILL
336: , Hz_Parties RAC_BILL_PARTY
337: -- added by Allen Yang 24-Sep-2009 for bug 8920326
338: -----------------------------------------------------

Line 3843: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;

3839: l_gta_batch_num_from ar_gta_trx_headers_all.gta_batch_number%TYPE
3840: :=p_gta_batch_num_from;
3841: l_gta_batch_num_to ar_gta_trx_headers_all.gta_batch_number%TYPE
3842: :=p_gta_batch_num_to;
3843: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;
3844: l_cust_num_from hz_cust_accounts.account_number%TYPE
3845: :=p_cust_num_from;
3846: l_cust_num_to hz_cust_accounts.account_number%TYPE
3847: :=p_cust_num_to;

Line 3926: ra_cust_trx_types_all

3922: CURSOR c_ar_transaction_type IS
3923: SELECT
3924: name
3925: FROM
3926: ra_cust_trx_types_all
3927: WHERE cust_trx_type_id=p_ar_transaction_type;
3928:
3929: CURSOR c_customer_name IS
3930: SELECT

Line 5677: , ra_cust_trx_types rctt

5673: l_ret_xmlelement
5674: FROM
5675: AR_Gta_Trx_Headers_all jgtha
5676: , ra_customer_trx_all rcta
5677: , ra_cust_trx_types rctt
5678: WHERE jgtha.CONSOLIDATION_FLAG = '1'
5679: AND jgtha.SOURCE = 'AR'
5680: AND jgtha.Status='CONSOLIDATED'
5681: AND jgtha.CONSOLIDATION_TRX_NUM =