DBA Data[Home] [Help]

APPS.ARP_DET_DIST_PKG dependencies on PSA_MF_BALANCES_VIEW

Line 8173: FROM psa_mf_balances_view

8169: CURSOR cmfar(p_customer_trx_id IN NUMBER) IS
8170: SELECT SUM(NVL(amount_due_remaining,0)) sum_due_rem,
8171: SUM(NVL(amount_due_original,0)) sum_due_orig,
8172: customer_trx_line_id customer_trx_line_id
8173: FROM psa_mf_balances_view
8174: WHERE customer_trx_id = p_customer_trx_id
8175: GROUP BY customer_trx_line_id;
8176: l_rem_amt_tab DBMS_SQL.NUMBER_TABLE;
8177: l_orig_amt_tab DBMS_SQL.NUMBER_TABLE;