DBA Data[Home] [Help]

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