APPS.AS_VALIDATE_SETUP dependencies on FND_LOOKUP_VALUES

Line 89: FROM FND_LOOKUP_VALUES LOOKUP

85: SELECT OPP.CURRENCY_CODE
86: FROM AS_LEADS_ALL OPP
87: WHERE OPP.CURRENCY_CODE NOT IN (
88: SELECT LOOKUP.LOOKUP_CODE
89: FROM FND_LOOKUP_VALUES LOOKUP
90: WHERE LOOKUP.LOOKUP_TYPE = 'REPORTING_CURRENCY'
91: AND LOOKUP.ENABLED_FLAG = 'Y');
92: -- end SOLIN, 06/12/2001
93:

Line 521: ( select 1 from FND_LOOKUP_VALUES flv

517: WHERE aslkp.lookup_type = 'INTERACTION_TYPE'
518: and aslkp.lookup_code not in ('MAIL_BLITZ','MAILED_IN_RESPONSE'
519: ,'INBOUND','OUTBOUND','VISIT')
520: and not exists
521: ( select 1 from FND_LOOKUP_VALUES flv
522: where flv.lookup_code = aslkp.lookup_code
523: and flv.lookup_type = 'JTF_MEDIA_TYPE' );
524: EXCEPTION
525: WHEN OTHERS THEN

Line 870: -- FND_LOOKUP_VALUES with lookup_type='REPORTING_CURRENCY'

866: END IF;
867: END;
868: -- SOLIN, 06/12/2001
869: -- AS_MC_REPORTING_CURR will be obsolete and migrate to
870: -- FND_LOOKUP_VALUES with lookup_type='REPORTING_CURRENCY'
871: IF p_upgrade = 'N' THEN
872: BEGIN
873: SELECT count(*) INTO l_count
874: FROM FND_LOOKUP_VALUES

Line 874: FROM FND_LOOKUP_VALUES

870: -- FND_LOOKUP_VALUES with lookup_type='REPORTING_CURRENCY'
871: IF p_upgrade = 'N' THEN
872: BEGIN
873: SELECT count(*) INTO l_count
874: FROM FND_LOOKUP_VALUES
875: WHERE ENABLED_FLAG = 'Y'
876: AND LOOKUP_TYPE = 'REPORTING_CURRENCY';
877: EXCEPTION
878: WHEN OTHERS THEN