eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_RECIPIENT_WF dependencies on GL_LEDGERS

Line 2441: gl_ledgers l

2437: ,b.gl_date
2438: FROM fun_trx_batches b,
2439: fun_trx_headers t,
2440: fun_trx_types_vl y,
2441: gl_ledgers l
2442: WHERE b.batch_id = t.batch_id
2443: AND b.trx_type_id = y.trx_type_id
2444: AND t.to_ledger_id = l.ledger_id
2445: AND t.trx_id = p_trx_id;

Line 2492: l_to_coa_id gl_ledgers.chart_of_accounts_id%TYPE;

2488: l_init_count NUMBER;
2489: l_reci_count NUMBER;
2490: l_to_bsv VARCHAR2(30);
2491:
2492: l_to_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2493: l_from_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2494:
2495: BEGIN
2496:

Line 2493: l_from_coa_id gl_ledgers.chart_of_accounts_id%TYPE;

2489: l_reci_count NUMBER;
2490: l_to_bsv VARCHAR2(30);
2491:
2492: l_to_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2493: l_from_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
2494:
2495: BEGIN
2496:
2497: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2653: from gl_ledgers l

2649: END IF;
2650:
2651: SELECT l.chart_of_accounts_id
2652: INTO l_from_coa_id
2653: from gl_ledgers l
2654: WHERE l.ledger_id = l_trx_dtl_rec.from_ledger_id;
2655:
2656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'l_from_coa_id = ' || l_from_coa_id);

Line 3045: from gl_ledgers l

3041:
3042:
3043: SELECT l.chart_of_accounts_id
3044: INTO l_to_coa_id
3045: from gl_ledgers l
3046: WHERE l.ledger_id = l_trx_dtl_rec.to_ledger_id;
3047:
3048: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3049: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'recipient coa id = ' || l_to_coa_id);

Line 3530: gl_ledgers l

3526: ,b.gl_date
3527: FROM fun_trx_batches b,
3528: fun_trx_headers t,
3529: fun_trx_types_vl y,
3530: gl_ledgers l
3531: WHERE b.batch_id = t.batch_id
3532: AND b.trx_type_id = y.trx_type_id
3533: AND t.to_ledger_id = l.ledger_id
3534: AND t.trx_id = p_trx_id;