APPS.IGS_PS_VAL_FSR dependencies on IGS_FI_FND_SRC_RSTN

Line 13: FROM IGS_FI_FND_SRC_RSTN

9: p_message_name OUT NOCOPY VARCHAR2 )
10: RETURN BOOLEAN AS
11: CURSOR c_count_all_fs IS
12: SELECT COUNT(*)
13: FROM IGS_FI_FND_SRC_RSTN
14: WHERE course_cd = p_course_cd AND
15: version_number = p_version_number;
16: CURSOR c_count_restrct_fs IS
17: SELECT COUNT(*)

Line 18: FROM IGS_FI_FND_SRC_RSTN

14: WHERE course_cd = p_course_cd AND
15: version_number = p_version_number;
16: CURSOR c_count_restrct_fs IS
17: SELECT COUNT(*)
18: FROM IGS_FI_FND_SRC_RSTN
19: WHERE course_cd = p_course_cd AND
20: version_number = p_version_number AND
21: restricted_ind = 'Y';
22: BEGIN

Line 125: v_funding_source_rest_rec IGS_FI_FND_SRC_RSTN%ROWTYPE;

121: p_course_cd IN VARCHAR2 ,
122: p_version_number IN NUMBER ,
123: p_message_name OUT NOCOPY VARCHAR2 )
124: RETURN BOOLEAN AS
125: v_funding_source_rest_rec IGS_FI_FND_SRC_RSTN%ROWTYPE;
126: CURSOR c_funding_source_rest IS
127: SELECT *
128: FROM IGS_FI_FND_SRC_RSTN
129: WHERE course_cd = p_course_cd AND

Line 128: FROM IGS_FI_FND_SRC_RSTN

124: RETURN BOOLEAN AS
125: v_funding_source_rest_rec IGS_FI_FND_SRC_RSTN%ROWTYPE;
126: CURSOR c_funding_source_rest IS
127: SELECT *
128: FROM IGS_FI_FND_SRC_RSTN
129: WHERE course_cd = p_course_cd AND
130: version_number = p_version_number AND
131: dflt_ind = 'Y';
132: BEGIN