APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_OFR_INST

Line 411: FROM IGS_PS_OFR_INST

407: FROM IGS_PS_STAT
408: WHERE course_status = p_old_course_status;
409: CURSOR c_course_offering_instance IS
410: SELECT cal_type, ci_sequence_number
411: FROM IGS_PS_OFR_INST
412: WHERE course_cd = p_course_cd AND
413: version_number = p_version_number;
414: BEGIN
415: OPEN c_course_version;

Line 638: -- Validate IGS_PS_OFR_INST record(s) if

634: RETURN FALSE;
635: END IF;
636: -- Validate IGS_PS_ENT_PT_REF_CD record(s) if
637: -- it exists and that IGS_GE_REF_CD_TYPE is not closed.
638: -- Validate IGS_PS_OFR_INST record(s) if
639: -- it exists and the IGS_CA_INST.IGS_CA_STAT is ACTIVE.
640: -- Only perform these if course_offering_records exist.
641: IF (v_coo_exist = TRUE) THEN
642: FOR ceprc_rec IN c_get_dist_reference_cd_type LOOP