APPS.OE_VALIDATE dependencies on OE_DELIVER_TO_ORGS_V

Line 4056: FROM OE_DELIVER_TO_ORGS_V DEL

4052: END IF;
4053:
4054: SELECT 'VALID'
4055: INTO l_dummy
4056: FROM OE_DELIVER_TO_ORGS_V DEL
4057: WHERE DEL.ORGANIZATION_ID =p_deliver_to_org_id
4058: AND DEL.STATUS = 'A'
4059: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
4060: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)