APPS.AR_GTA_ARTRX_PROC dependencies on GL_PERIODS

Line 952: , GL_PERIODS GP

948: , ra_batches_all b
949: , Ra_Cust_Trx_Line_Gl_Dist_All gd
950: , Hz_Parties RAC_BILL_PARTY
951: , Hz_Cust_Accounts RAC_BILL
952: , GL_PERIODS GP
953: WHERE h.complete_flag = ''Y''
954: AND h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
955: AND ctt.TYPE IN (''INV'', ''CM'', ''DM'')
956: AND h.batch_id = b.batch_id(+)

Line 2081: l_period_name GL_PERIODS.Period_Name%TYPE;

2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2080: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2081: l_period_name GL_PERIODS.Period_Name%TYPE;
2082: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2083:
2084: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
2085: l_invoice_type_code ar_gta_tax_limits_all.invoice_type%TYPE; --added for bug 13942623

Line 2493: GL_PERIODS GP -- period

2489: ra_batches_all b,
2490: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2491: Hz_Parties RAC_BILL_PARTY,
2492: Hz_Cust_Accounts RAC_BILL,
2493: GL_PERIODS GP -- period
2494: WHERE h.complete_flag = 'Y'
2495: AND h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
2496: AND ctt.TYPE IN ('INV', 'CM', 'DM')
2497: AND h.batch_id = b.batch_id(+)