DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_PS_PAT_OF_STUDY

Line 4231: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS

4227: l_pos_count NUMBER(1) := 0;
4228: l_rowid VARCHAR2(25);
4229: l_seqval igs_as_su_setatmpt.sequence_number%TYPE ;
4230:
4231: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS
4232: SELECT unit_set_cd
4233: FROM IGS_PS_PAT_OF_STUDY pos
4234: WHERE course_cd = p_course_cd AND
4235: version_number = cp_version_number AND

Line 4233: FROM IGS_PS_PAT_OF_STUDY pos

4229: l_seqval igs_as_su_setatmpt.sequence_number%TYPE ;
4230:
4231: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS
4232: SELECT unit_set_cd
4233: FROM IGS_PS_PAT_OF_STUDY pos
4234: WHERE course_cd = p_course_cd AND
4235: version_number = cp_version_number AND
4236: cal_type = p_acad_cal_type AND
4237: unit_set_cd IN