APPS.OE_BULK_VALIDATE dependencies on OE_RA_TERMS_V

Line 864: FROM OE_RA_TERMS_V a

860: FROM OE_HEADERS_IFACE_ALL b
861: WHERE batch_id = p_batch_id and
862: b.payment_term_id IS NOT NULL and
863: NOT EXISTS (select a.TERM_ID
864: FROM OE_RA_TERMS_V a
865: WHERE TERM_ID = b.payment_term_id
866: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
867: AND NVL(END_DATE_ACTIVE, SYSDATE))
868: ;

Line 903: FROM OE_RA_TERMS_V a

899: FROM OE_HEADERS_IFACE_ALL
900: WHERE batch_id = p_batch_id)
901: AND b.payment_term_id IS NOT NULL and
902: NOT EXISTS (select a.TERM_ID
903: FROM OE_RA_TERMS_V a
904: WHERE TERM_ID = b.payment_term_id
905: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
906: AND NVL(END_DATE_ACTIVE, SYSDATE));
907: