DBA Data[Home] [Help]

APPS.PSA_MFAR_ADJUSTMENTS dependencies on AR_RECEIVABLES_TRX

Line 390: FROM ar_receivables_trx r, ar_adjustments a

386: -- Bug 3140981: c_adj_gl_source to identify the adjustment type's GL Account source
387:
388: CURSOR c_adj_gl_source IS
389: SELECT gl_account_source
390: FROM ar_receivables_trx r, ar_adjustments a
391: WHERE r.receivables_trx_id = a.receivables_trx_id
392: AND a.adjustment_id = g_adjustment_id;
393:
394:

Line 415: l_adj_gl_source ar_receivables_trx_all.gl_account_source%TYPE;

411: l_exception_error VARCHAR2(2000);
412: FLEX_BUILD_ERROR EXCEPTION;
413:
414: sum_amt_due_rem NUMBER;
415: l_adj_gl_source ar_receivables_trx_all.gl_account_source%TYPE;
416: l_adj_ccid NUMBER(15);
417:
418: l_distr_line_count NUMBER;
419: l_count number := 0; /*for temporary table*/