APPS.IGF_AP_OSS_INTEGR dependencies on IGS_PE_MIL_SERVICES

Line 56: FROM igs_pe_mil_services ms,

52:
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