APPS.PSA_MFAR_ADJUSTMENTS dependencies on PSA_MF_TRX_DIST_ALL

Line 120: psa_mf_trx_dist_all B,

116: C.mf_adjustment_ccid mf_adj_ccid,
117: C.prev_mf_adjustment_ccid prev_mf_adj_ccid,
118: C.prev_cust_trx_line_id prev_cust_trx_line_id
119: From ra_cust_trx_line_gl_dist A,
120: psa_mf_trx_dist_all B,
121: psa_mf_adj_dist_all C
122: Where C.adjustment_id = g_adjustment_id
123: And A.customer_trx_id = g_customer_trx_id
124: And A.CUST_TRX_LINE_GL_DIST_ID = B.CUST_TRX_LINE_GL_DIST_ID

Line 375: psa_mf_trx_dist_all C,

371: D.amount_due_remaining) amount_due,
372: B.percent -- panatara
373: From ra_customer_trx_lines A,
374: ra_cust_trx_line_gl_dist B,
375: psa_mf_trx_dist_all C,
376: psa_mf_balances_view D
377: Where A.customer_trx_id = g_customer_trx_id
378: and A.customer_trx_line_id = B.customer_trx_line_id
379: and B.account_class <> 'REC'

Line 491: psa_mf_trx_dist_all C,

487: ELSE
488: SELECT count(*) INTO l_distr_line_count
489: FROM ra_customer_trx_lines A,
490: ra_cust_trx_line_gl_dist B,
491: psa_mf_trx_dist_all C,
492: psa_mf_balances_view D
493: WHERE A.customer_trx_id = g_customer_trx_id
494: and A.customer_trx_line_id = B.customer_trx_line_id
495: and B.account_class <> 'REC'