APPS.IGS_PS_VAL_POSP dependencies on IGS_PS_PAT_STUDY_PRD

Line 129: -- Validate IGS_PS_PAT_STUDY_PRD records. More than one record cannot

125: p_teach_cal_type IN VARCHAR2 ,
126: p_message_name OUT NOCOPY VARCHAR2)
127: RETURN BOOLEAN AS
128: BEGIN -- crsp_val_posp_iu
129: -- Validate IGS_PS_PAT_STUDY_PRD records. More than one record cannot
130: -- exist with the same academic period number and teaching calendar type
131: -- for a parent IGS_PS_PAT_OF_STUDY.
132: DECLARE
133: v_dummy VARCHAR(1);

Line 136: FROM IGS_PS_PAT_STUDY_PRD posp

132: DECLARE
133: v_dummy VARCHAR(1);
134: CURSOR c_posp IS
135: SELECT 'X'
136: FROM IGS_PS_PAT_STUDY_PRD posp
137: WHERE posp.course_cd = p_course_cd AND
138: posp.version_number = p_version_number AND
139: posp.cal_type = p_cal_type AND
140: posp.pos_sequence_number = p_pos_sequence_number AND