APPS.OE_VALIDATE dependencies on OE_AR_LOOKUPS_V

Line 3229: FROM OE_AR_LOOKUPS_V

3225: END IF;
3226:
3227: SELECT 'VALID'
3228: INTO l_dummy
3229: FROM OE_AR_LOOKUPS_V
3230: WHERE LOOKUP_CODE = p_fob_point_code
3231: AND LOOKUP_TYPE = l_lookup_type
3232: AND ENABLED_FLAG = 'Y'
3233: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 18675: FROM OE_AR_LOOKUPS_V

18671: END IF;
18672:
18673: SELECT 'VALID'
18674: INTO l_dummy
18675: FROM OE_AR_LOOKUPS_V
18676: WHERE LOOKUP_CODE = p_return_reason_code
18677: AND LOOKUP_TYPE = l_lookup_type
18678: AND ENABLED_FLAG = 'Y'
18679: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)