DBA Data[Home] [Help]

APPS.JMF_GTA_ARTRX_PROC dependencies on GL_PERIODS

Line 915: , GL_PERIODS GP

911: , ra_batches_all b
912: , Ra_Cust_Trx_Line_Gl_Dist_All gd
913: , Hz_Parties RAC_BILL_PARTY
914: , Hz_Cust_Accounts RAC_BILL
915: , GL_PERIODS GP
916: WHERE h.complete_flag = ''Y''
917: AND h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
918: AND ctt.TYPE IN (''INV'', ''CM'', ''DM'')
919: AND h.batch_id = b.batch_id(+)

Line 2025: l_period_name GL_PERIODS.Period_Name%TYPE;

2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2025: l_period_name GL_PERIODS.Period_Name%TYPE;
2026: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2027:
2028: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;
2029:

Line 2397: GL_PERIODS GP -- period

2393: ra_batches_all b,
2394: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2395: Hz_Parties RAC_BILL_PARTY,
2396: Hz_Cust_Accounts RAC_BILL,
2397: GL_PERIODS GP -- period
2398: WHERE h.complete_flag = 'Y'
2399: AND h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
2400: AND ctt.TYPE IN ('INV', 'CM', 'DM')
2401: AND h.batch_id = b.batch_id(+)