DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on GMF_RCV_ACCOUNTING_TXNS

Line 2550: SELECT 1 FROM gmf_rcv_accounting_txns

2546: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2547: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2548:
2549: CURSOR c_opm_count IS
2550: SELECT 1 FROM gmf_rcv_accounting_txns
2551: WHERE org_id = p_operating_unit
2552: AND rownum < 2;
2553: l_opm_count NUMBER;
2554:

Line 3149: gmf_rcv_accounting_txns grat

3145: SELECT /*+ LEADING(rt) USE_NL(grat,pod) */
3146: DISTINCT pod.po_distribution_id
3147: FROM po_distributions_all pod,
3148: rcv_transactions rt,
3149: gmf_rcv_accounting_txns grat
3150: WHERE pod.accrual_account_id is NOT NULL
3151: AND pod.accrue_on_receipt_flag = 'Y'
3152: AND rt.transaction_date between p_from_date AND p_to_date
3153: AND pod.org_id = p_operating_unit

Line 3210: SELECT 1 FROM gmf_rcv_accounting_txns

3206:
3207: po_dists_tab dists_table;
3208:
3209: CURSOR c_opm_count IS
3210: SELECT 1 FROM gmf_rcv_accounting_txns
3211: WHERE org_id = p_operating_unit
3212: AND rownum <2 ;
3213: l_opm_count NUMBER;
3214:

Line 3444: gmf_rcv_accounting_txns grat,

3440: l_request_id,
3441: xal.ae_header_id,
3442: xal.ae_line_num
3443: FROM rcv_transactions rct,
3444: gmf_rcv_accounting_txns grat,
3445: gmf_xla_extract_headers geh,
3446: gmf_xla_extract_lines gel,
3447: xla_ae_headers xah,
3448: xla_ae_lines xal,