1932: | ** commitment balance |
1933: +---------------------------------------------------------------*/
1934:
1935:
1936: -- replace OE_ACCOUNTING with OE_Payments_Util
1937: SELECT NVL( l_commitment_bal, 0 ) -
1938: NVL(OE_Payments_Util.Get_Uninvoiced_Commitment_Bal(p_customer_trx_id), 0)
1939: INTO l_commitment_bal
1940: FROM dual;
1934:
1935:
1936: -- replace OE_ACCOUNTING with OE_Payments_Util
1937: SELECT NVL( l_commitment_bal, 0 ) -
1938: NVL(OE_Payments_Util.Get_Uninvoiced_Commitment_Bal(p_customer_trx_id), 0)
1939: INTO l_commitment_bal
1940: FROM dual;
1941:
1942: /*------------------------------------------------------------+