DBA Data[Home] [Help]

APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_OFR_OPT

Line 396: FROM IGS_PS_OFR_OPT

392: CURSOR c_course_offering_option IS
393: SELECT location_cd,
394: attendance_type,
395: attendance_mode
396: FROM IGS_PS_OFR_OPT
397: WHERE course_cd = p_course_cd AND
398: version_number = p_version_number AND
399: delete_flag = 'N';
400: CURSOR c_get_dist_reference_cd_type IS

Line 610: -- Validate IGS_PS_OFR_OPT record(s) if it exists and

606: END LOOP;
607: IF (v_terminate = TRUE) THEN
608: RETURN FALSE;
609: END IF;
610: -- Validate IGS_PS_OFR_OPT record(s) if it exists and
611: -- the closed indicators associated with the fields of the record
612: FOR coo_rec IN c_course_offering_option LOOP
613: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_COO.crsp_val_loc_cd
614: IF (IGS_PS_VAL_UOO.crsp_val_loc_cd(