APPS.OE_INVOICE_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 161: FROM AR_PAYMENT_SCHEDULES

157: IF ( P_CUSTOMER_TRX_ID IS NOT NULL )
158: THEN
159: SELECT NVL(SUM(AMOUNT_DUE_REMAINING),0)
160: INTO v_balance
161: FROM AR_PAYMENT_SCHEDULES
162: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
163: END IF;
164: RETURN(v_balance);
165: EXCEPTION