APPS.IGS_RE_WORKFLOW dependencies on IGS_PS_VER

Line 1686: p_course_cd igs_ps_ver.course_cd%TYPE)IS

1682: FROM dual;
1683:
1684: --
1685: CURSOR cur_prog_ver ( p_person_id igs_pe_person.person_id%TYPE,
1686: p_course_cd igs_ps_ver.course_cd%TYPE)IS
1687: SELECT course_cd , version_number, attendance_type
1688: FROM igs_en_stdnt_ps_att
1689: WHERE person_id = p_person_id
1690: AND course_cd = p_course_cd ;

Line 1863: p_course_cd igs_ps_ver.course_cd%TYPE)IS

1859: FROM dual;
1860:
1861: --
1862: CURSOR cur_prog_stat ( p_person_id igs_pe_person.person_id%TYPE,
1863: p_course_cd igs_ps_ver.course_cd%TYPE)IS
1864: SELECT course_attempt_status
1865: FROM igs_en_stdnt_ps_att
1866: WHERE person_id = p_person_id
1867: AND course_cd = p_course_cd ;

Line 2168: p_programcd igs_ps_ver.course_cd%TYPE ) IS

2164: FROM dual;
2165:
2166:
2167: CURSOR cur_res_top (p_personid igs_pe_person_base_v.person_id%TYPE,
2168: p_programcd igs_ps_ver.course_cd%TYPE ) IS
2169: SELECT research_topic,sequence_number
2170: FROM igs_re_candidature
2171: WHERE person_id = p_personid
2172: AND sca_course_cd = p_programcd ;

Line 2174: CURSOR cur_course_type (p_programcd igs_ps_ver.course_cd%TYPE ) IS

2170: FROM igs_re_candidature
2171: WHERE person_id = p_personid
2172: AND sca_course_cd = p_programcd ;
2173:
2174: CURSOR cur_course_type (p_programcd igs_ps_ver.course_cd%TYPE ) IS
2175: SELECT course_type
2176: FROM igs_ps_ver
2177: WHERE course_cd=p_programcd ;
2178:

Line 2176: FROM igs_ps_ver

2172: AND sca_course_cd = p_programcd ;
2173:
2174: CURSOR cur_course_type (p_programcd igs_ps_ver.course_cd%TYPE ) IS
2175: SELECT course_type
2176: FROM igs_ps_ver
2177: WHERE course_cd=p_programcd ;
2178:
2179: l_cur_res_top cur_res_top%ROWTYPE;
2180: l_cur_course_type cur_course_type%ROWTYPE;