APPS.IGF_AP_OSS_INTEGR dependencies on IGS_LOOKUP_VALUES

Line 57: igs_lookup_values cc

53: CURSOR c_get_mil_service IS
54: SELECT cc.lookup_code service_type,
55: cc.meaning service_desc
56: FROM igs_pe_mil_services ms,
57: igs_lookup_values cc
58: WHERE cc.lookup_code = ms.military_type_cd
59: AND cc.lookup_type = 'PE_MIL_SEV_TYPE'
60: AND ms.person_id = p_person_id
61: ORDER BY ms.milit_service_id;