DBA Data[Home] [Help]

APPS.JE_INTERFACE_VAL dependencies on FND_LOOKUPS

Line 618: FROM fnd_lookups

614: IF p_glob_attr_set1.global_attribute1 IS NOT NULL THEN
615: BEGIN
616: SELECT 1
617: INTO dummy_code
618: FROM fnd_lookups
619: WHERE lookup_code=p_glob_attr_set1.global_attribute1
620: AND lookup_type = 'YES_NO'
621: AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
622: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE

Line 664: FROM fnd_lookups

660: IF p_glob_attr_set3.global_attribute1 IS NOT NULL THEN
661: BEGIN
662: SELECT 1
663: INTO dummy_code
664: FROM fnd_lookups
665: WHERE lookup_code=p_glob_attr_set3.global_attribute1
666: AND lookup_type = 'YES_NO'
667: AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
668: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE