APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on GL_LEDGERS

Line 212: gl_ledgers sob

208: NVL(dist.ACCTD_AMOUNT_CR,0)-NVL(dist.ACCTD_AMOUNT_DR,0)
209: FROM xla_events_gt eve,
210: ar_receivable_applications_all app,
211: ar_distributions_all dist,
212: gl_ledgers sob
213: WHERE eve.application_id = 222
214: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')
215: AND eve.event_id = app.event_id
216: AND app.status IN ('APP','ACTIVITY')

Line 3891: FROM gl_ledgers gl,

3887: PROCEDURE mfar_hook(p_ledger_id IN NUMBER)
3888: IS
3889: CURSOR c IS
3890: SELECT NULL
3891: FROM gl_ledgers gl,
3892: xla_acctg_method_rules mr,
3893: xla_product_rules_tl pr
3894: WHERE gl.ledger_id = p_ledger_id
3895: AND mr.application_id = 222

Line 4136: gl_ledgers lg

4132: FROM xla_events_gt gt,
4133: ar_cash_receipt_history_all crh,
4134: ar_cash_receipts_all cr,
4135: ar_distributions_all ard,
4136: gl_ledgers lg
4137: WHERE gt.application_id = 222
4138: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE')
4139: AND gt.event_id = crh.event_id
4140: AND crh.postable_flag = 'Y'

Line 4474: gl_ledgers lg,

4470: ra_customer_trx_all trx,
4471: ra_cust_trx_line_gl_dist_all ctlgd,
4472: ra_customer_trx_lines_all ctl,
4473: ar_cash_receipts_all cr,
4474: gl_ledgers lg,
4475: ar_cash_receipt_history_all crhlatest
4476: WHERE gt.application_id = 222
4477: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE')
4478: AND gt.event_id = ra.event_id