APPS.IGS_AD_VAL_ACAI dependencies on IGS_FI_FND_SRC_RSTN

Line 4935: FROM IGS_FI_FND_SRC_RSTN fsr

4931: v_fs_found BOOLEAN := FALSE;
4932: v_message_name VARCHAR2(30);
4933: CURSOR c_fsr IS
4934: SELECT fsr.funding_source
4935: FROM IGS_FI_FND_SRC_RSTN fsr
4936: WHERE fsr.course_cd = p_course_cd AND
4937: fsr.version_number = p_version_number AND
4938: fsr.restricted_ind = 'Y';
4939: BEGIN

Line 4961: -- No records found in IGS_FI_FND_SRC_RSTN

4957: EXIT;
4958: END IF;
4959: END LOOP;
4960: IF v_fsr_found = FALSE THEN
4961: -- No records found in IGS_FI_FND_SRC_RSTN
4962: RETURN TRUE;
4963: ELSIF v_fs_found = TRUE THEN
4964: -- Records found in IGS_FI_FND_SRC_RSTN
4965: -- found source is valid for the course version

Line 4964: -- Records found in IGS_FI_FND_SRC_RSTN

4960: IF v_fsr_found = FALSE THEN
4961: -- No records found in IGS_FI_FND_SRC_RSTN
4962: RETURN TRUE;
4963: ELSIF v_fs_found = TRUE THEN
4964: -- Records found in IGS_FI_FND_SRC_RSTN
4965: -- found source is valid for the course version
4966: RETURN TRUE;
4967: ELSE
4968: -- Records found in IGS_FI_FND_SRC_RSTN

Line 4968: -- Records found in IGS_FI_FND_SRC_RSTN

4964: -- Records found in IGS_FI_FND_SRC_RSTN
4965: -- found source is valid for the course version
4966: RETURN TRUE;
4967: ELSE
4968: -- Records found in IGS_FI_FND_SRC_RSTN
4969: -- found source is not valid for the course version
4970: p_message_name := 'IGS_AD_FUNDSRC_NOTVALID_APPL';
4971: RETURN FALSE;
4972: END IF;