APPS.IGS_AD_SS_GEN_001 dependencies on IGS_LOOKUP_VALUES

Line 4688: igs_lookup_values lkv

4684: SELECT
4685: DISTINCT conf.page_code,
4686: lkv.meaning page_desc
4687: FROM igs_ad_ss_appl_conf conf,
4688: igs_lookup_values lkv
4689: WHERE
4690: lkv.lookup_type = 'SS_APPL_SELFSERVICE_PAGES'
4691: AND lkv.lookup_code = conf.page_code
4692: AND lkv.ENABLED_FLAG = 'Y'

Line 4701: igs_lookup_values lkv

4697: SELECT conf.page_code, conf.component_code,
4698: lkv.meaning component_desc,
4699: conf.include_flag, conf.apc_step
4700: FROM IGS_AD_SS_APPL_CONF conf,
4701: igs_lookup_values lkv
4702: WHERE
4703: lkv.lookup_type = 'IGS_AD_SS_PG_COMPS'
4704: AND lkv.lookup_code = conf.component_code
4705: AND conf.page_code = cp_page_code

Line 5649: FROM igs_lookup_values lv

5645: sslkps.closed_flag <> 'Y');
5646:
5647: CURSOR c_alias_type IS
5648: SELECT lv.meaning lookup_desc
5649: FROM igs_lookup_values lv
5650: WHERE lv.LOOKUP_TYPE = 'PE_ALIAS_TYPE'
5651: AND lv.ENABLED_FLAG = 'Y'
5652: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5653: WHERE sslkps.SS_LOOKUP_TYPE = 'PE_ALIAS_TYPE' AND