DBA Data[Home] [Help]

APPS.ARP_DET_DIST_PKG dependencies on PSA_MF_BALANCES_VIEW

Line 9590: FROM psa_mf_balances_view

9586: CURSOR cmfar(p_customer_trx_id IN NUMBER) IS
9587: SELECT SUM(NVL(amount_due_remaining,0)) sum_due_rem,
9588: SUM(NVL(amount_due_original,0)) sum_due_orig,
9589: customer_trx_line_id customer_trx_line_id
9590: FROM psa_mf_balances_view
9591: WHERE customer_trx_id = p_customer_trx_id
9592: GROUP BY customer_trx_line_id;
9593: l_rem_amt_tab DBMS_SQL.NUMBER_TABLE;
9594: l_orig_amt_tab DBMS_SQL.NUMBER_TABLE;