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 18481: FROM OE_AR_LOOKUPS_V

18477: END IF;
18478:
18479: SELECT 'VALID'
18480: INTO l_dummy
18481: FROM OE_AR_LOOKUPS_V
18482: WHERE LOOKUP_CODE = p_return_reason_code
18483: AND LOOKUP_TYPE = l_lookup_type
18484: AND ENABLED_FLAG = 'Y'
18485: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)