APPS.IGS_PS_VAL_CRV dependencies on IGS_FI_FND_SRC_RSTN

Line 333: v_funding_source IGS_FI_FND_SRC_RSTN.funding_source%TYPE;

329: ***************************************************************/
330:
331: v_cv_rec IGS_PS_VER%ROWTYPE;
332: v_award_cd IGS_PS_AWARD.award_cd%TYPE;
333: v_funding_source IGS_FI_FND_SRC_RSTN.funding_source%TYPE;
334: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
335: v_field_of_study IGS_PS_FIELD_STUDY.field_of_study%TYPE;
336: v_course_cat IGS_PS_CATEGORISE.course_cat%TYPE;
337: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;

Line 358: FROM IGS_FI_FND_SRC_RSTN

354: version_number = p_version_number AND
355: CLOSED_IND = 'N';
356: CURSOR c_get_funding_source IS
357: SELECT funding_source
358: FROM IGS_FI_FND_SRC_RSTN
359: WHERE course_cd = p_course_cd AND
360: version_number = p_version_number;
361: CURSOR c_get_field_of_study IS
362: SELECT field_of_study

Line 508: -- Validate the IGS_FI_FND_SRC_RSTN table and that the

504: RETURN FALSE;
505: END IF;
506: CLOSE c_get_award_cd;
507: END IF; -- course_award_ind is 'Y'
508: -- Validate the IGS_FI_FND_SRC_RSTN table and that the
509: -- IGS_FI_FUND_SRC is not closed.
510: FOR fs_rec IN c_get_funding_source LOOP
511: IF (IGS_PS_VAL_FSr.crsp_val_fsr_fnd_src(
512: fs_rec.funding_source,