DBA Data[Home] [Help]

APPS.JE_INTERFACE_VAL dependencies on FND_LOOKUPS

Line 624: FROM fnd_lookups

620: IF p_glob_attr_set1.global_attribute1 IS NOT NULL THEN
621: BEGIN
622: SELECT 1
623: INTO dummy_code
624: FROM fnd_lookups
625: WHERE lookup_code=p_glob_attr_set1.global_attribute1
626: AND lookup_type = 'YES_NO'
627: AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
628: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE

Line 670: FROM fnd_lookups

666: IF p_glob_attr_set3.global_attribute1 IS NOT NULL THEN
667: BEGIN
668: SELECT 1
669: INTO dummy_code
670: FROM fnd_lookups
671: WHERE lookup_code=p_glob_attr_set3.global_attribute1
672: AND lookup_type = 'YES_NO'
673: AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
674: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE