APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_USEC_OCCURS_ALL

Line 2355: FROM igs_ps_usec_occurs_all

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';
2358:
2359: l_c_var VARCHAR2(1);

Line 2361: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

2357: AND schedule_status = 'PROCESSING';
2358:
2359: l_c_var VARCHAR2(1);
2360:
2361: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
2362: SELECT uso.unit_section_occurrence_id
2363: FROM igs_ps_usec_occurs_all uso
2364: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
2365: AND uso.no_set_day_ind ='N'

Line 2363: FROM igs_ps_usec_occurs_all uso

2359: l_c_var VARCHAR2(1);
2360:
2361: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
2362: SELECT uso.unit_section_occurrence_id
2363: FROM igs_ps_usec_occurs_all uso
2364: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
2365: AND uso.no_set_day_ind ='N'
2366: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
2367: