APPS.IGS_EN_VAL_SCA dependencies on IGS_FI_FND_SRC_RSTN

Line 1820: FROM IGS_FI_FND_SRC_RSTN

1816: cp_course_cd IGS_PS_VER.course_cd%TYPE,
1817: cp_version_number IGS_PS_VER.version_number%TYPE) IS
1818: SELECT funding_source,
1819: restricted_ind
1820: FROM IGS_FI_FND_SRC_RSTN
1821: WHERE course_cd = cp_course_cd AND
1822: version_number = cp_version_number AND
1823: restricted_ind = 'Y';
1824: BEGIN

Line 1826: -- to the IGS_FI_FND_SRC_RSTN table held against the course

1822: version_number = cp_version_number AND
1823: restricted_ind = 'Y';
1824: BEGIN
1825: -- validates the funding source for a student course attempt according
1826: -- to the IGS_FI_FND_SRC_RSTN table held against the course
1827: p_message_name := null;
1828: v_rec_found := FALSE;
1829: FOR v_fund_source_rest_rec IN c_fund_source_rest(
1830: p_course_cd,

Line 2508: FROM IGS_FI_FND_SRC_RSTN

2504: FROM IGS_FI_FUND_SRC
2505: WHERE funding_source = p_funding_source;
2506: CURSOR c_chk_fsr_fs IS
2507: SELECT 'Y'
2508: FROM IGS_FI_FND_SRC_RSTN
2509: WHERE course_cd = p_course_cd AND
2510: version_number = p_version_number AND
2511: funding_source = p_funding_source AND
2512: restricted_ind = 'Y';

Line 2515: FROM IGS_FI_FND_SRC_RSTN

2511: funding_source = p_funding_source AND
2512: restricted_ind = 'Y';
2513: CURSOR c_chk_fsr_cv IS
2514: SELECT 'Y'
2515: FROM IGS_FI_FND_SRC_RSTN
2516: WHERE course_cd = p_course_cd AND
2517: version_number = p_version_number AND
2518: restricted_ind = 'Y';
2519: BEGIN

Line 2539: -- IGS_FI_FND_SRC_RSTN table

2535: END IF;
2536: -- the IGS_FI_FUND_SRC isn't closed in
2537: -- the IGS_FI_FUND_SRC table so
2538: -- check that the IGS_FI_FUND_SRC in the
2539: -- IGS_FI_FND_SRC_RSTN table
2540: -- doesn't breach existing restrictions
2541: OPEN c_chk_fsr_cv;
2542: FETCH c_chk_fsr_cv INTO v_fsr_cv_exists;
2543: CLOSE c_chk_fsr_cv;