DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on GL_BALANCES

Line 2623: FROM gl_balances

2619: decode(p_amount_type, 'FYTD',NVL(begin_balance_dr, 0), 'QTD'
2620: , NVL(quarter_to_date_dr, 0), 0) -
2621: decode(p_amount_type, 'FYTD', NVL(begin_balance_cr, 0), 'QTD'
2622: , NVL(quarter_to_date_cr, 0), 0)
2623: FROM gl_balances
2624: WHERE ledger_id = p_sob_id
2625: AND code_combination_id = p_source_ccid /** .source_ccid */
2626: AND currency_code = p_currency_code
2627: AND period_name = p_run_period

Line 2674: 'PA_AL_NO_GL_BALANCES');

2670: pa_debug.write_file('calculate_src_GL_amounts: ' || 'LOG', 'no amount found for the source');
2671: END IF;
2672: v_amount := 0; /* for bug 2154559 */
2673: alloc_errors( p_rule_id, p_run_id, 'S', 'W',
2674: 'PA_AL_NO_GL_BALANCES');
2675: END IF;
2676: CLOSE get_gl_amount;
2677: -- Commented the following line as a part of fixing rounding issues.
2678: -- The rounding is done for eligible amount