APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_USO_FACILITY

Line 3776: CURSOR c_ref_code (cp_uso_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS

3772: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
3773: AND uso.no_set_day_ind ='N'
3774: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
3775:
3776: CURSOR c_ref_code (cp_uso_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS
3777: SELECT 'X'
3778: FROM igs_ps_usec_occurs_all
3779: WHERE unit_section_occurrence_id = cp_uso_id
3780: AND schedule_status = 'PROCESSING';