APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_ANL_LOAD_U_LN

Line 384: FROM IGS_PS_ANL_LOAD_U_LN

380: version_number = p_version_number;
381: CURSOR c_course_annual_load_unit_link IS
382: SELECT unit_cd,
383: uv_version_number
384: FROM IGS_PS_ANL_LOAD_U_LN
385: WHERE course_cd = p_course_cd AND
386: crv_version_number =p_version_number;
387: CURSOR c_get_cal_type IS
388: SELECT cal_type

Line 573: -- Validate that if IGS_PS_ANL_LOAD_U_LN records exist,

569: END LOOP;
570: IF (v_terminate = TRUE) THEN
571: RETURN FALSE;
572: END IF;
573: -- Validate that if IGS_PS_ANL_LOAD_U_LN records exist,
574: -- check that the associated IGS_PS_UNIT version(s) is not inactive
575: FOR calul_rec IN c_course_annual_load_unit_link LOOP
576: IF (IGS_PS_VAL_CALul.crsp_val_uv_sys_sts(
577: calul_rec.unit_cd,