APPS.AS_VALIDATE_SETUP dependencies on AS_LOOKUPS

Line 268: from AS_LOOKUPS aslkp

264: FROM AS_CONTACT_FAMILY cf
265: WHERE not exists
266: ( select aslkp.lookup_code
267: , arlkp.lookup_code
268: from AS_LOOKUPS aslkp
269: ,AR_LOOKUPS arlkp
270: ,AS_CONTACT_FAMILY acf
271: where aslkp.lookup_type = 'CONTACT_RELATION'
272: and upper(ltrim(rtrim(aslkp.meaning))) =

Line 466: FROM AS_LOOKUPS aslkp

462: Write_Log(l_module, '**** Checking the setup for Task/Interaction module ****');
463:
464: BEGIN
465: SELECT count(*) INTO l_count
466: FROM AS_LOOKUPS aslkp
467: WHERE aslkp.lookup_type = 'TODO'
468: and not exists
469: ( select 1 from JTF_TASK_TYPES_VL
470: where upper(rtrim(ltrim(aslkp.meaning))) =

Line 491: FROM AS_LOOKUPS aslkp

487: END IF;
488:
489: BEGIN
490: SELECT count(*) INTO l_count
491: FROM AS_LOOKUPS aslkp
492: WHERE aslkp.lookup_type = 'TODO_PRIORITY'
493: and not exists
494: ( select 1 from JTF_TASK_PRIORITIES_VL
495: where upper(rtrim(ltrim(aslkp.meaning))) =

Line 516: FROM AS_LOOKUPS aslkp

512: END IF;
513:
514: BEGIN
515: SELECT count(*) INTO l_count
516: FROM AS_LOOKUPS aslkp
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