APPS.OE_QUERY dependencies on AR_PAYMENT_SCHEDULES
Line 1871: FROM AR_PAYMENT_SCHEDULES
1867: IF ( P_CUSTOMER_TRX_ID IS NOT NULL )
1868: THEN
1869: SELECT NVL(SUM(AMOUNT_DUE_REMAINING),0)
1870: INTO v_balance 1871: FROM AR_PAYMENT_SCHEDULES 1872: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
1873: END IF;
1874: RETURN(v_balance);
1875: EXCEPTION