APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_MEDIA_EQUIP_ALL

Line 2347: CURSOR cur_facility_closed (cp_facility_code igs_ps_media_equip_all.media_code%TYPE) IS

2343: Change History (in reverse chronological order)
2344: Who When What
2345: ********************************************************************************************** */
2346:
2347: CURSOR cur_facility_closed (cp_facility_code igs_ps_media_equip_all.media_code%TYPE) IS
2348: SELECT 'X'
2349: FROM igs_ps_media_equip_all
2350: WHERE media_code = cp_facility_code
2351: AND closed_ind = 'Y';

Line 2349: FROM igs_ps_media_equip_all

2345: ********************************************************************************************** */
2346:
2347: CURSOR cur_facility_closed (cp_facility_code igs_ps_media_equip_all.media_code%TYPE) IS
2348: SELECT 'X'
2349: FROM igs_ps_media_equip_all
2350: WHERE media_code = cp_facility_code
2351: AND closed_ind = 'Y';
2352:
2353: CURSOR c_facility (cp_uso_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS