APPS.IGF_AP_ISIR_GEN_PKG dependencies on IGF_LOOKUPS_VIEW

Line 2356: FROM igf_lookups_view mlkp, igf_lookups_view tlkp

2352: CURSOR get_message_class(
2353: cp_message_class igf_ap_isir_matched_all.message_class_txt%TYPE
2354: ) IS
2355: SELECT tlkp.meaning isir_type_desc, tlkp.lookup_code isir_type
2356: FROM igf_lookups_view mlkp, igf_lookups_view tlkp
2357: WHERE mlkp.enabled_flag = 'Y'
2358: AND tlkp.enabled_flag = 'Y'
2359: AND mlkp.lookup_type = 'IGF_AP_ISIR_MESSAGE_CLASS'
2360: AND tlkp.lookup_type = 'IGF_AP_ISIR_TYPE'