APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_USO_FACILITY

Line 2353: CURSOR c_facility (cp_uso_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS

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
2354: SELECT 'X'
2355: FROM igs_ps_usec_occurs_all
2356: WHERE unit_section_occurrence_id = cp_uso_id
2357: AND schedule_status = 'PROCESSING';