DBA Data[Home] [Help]

APPS.OE_VALIDATE_ADJ dependencies on OE_LOOKUPS

Line 1129: FROM OE_LOOKUPS

1125: END IF;
1126:
1127: SELECT 'VALID'
1128: INTO l_dummy
1129: FROM OE_LOOKUPS
1130: WHERE LOOKUP_CODE = p_change_reason_code
1131: AND LOOKUP_TYPE = l_lookup_type
1132: AND ENABLED_FLAG = 'Y'
1133: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE);