APPS.IGS_RE_GEN_002 dependencies on IGS_PS_VER

Line 255: p_course_cd IGS_PS_VER.course_cd%TYPE,

251: apcs.step_group_type <> 'TRACK'; --2402377
252: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
253: -- Local procedure used to get the research IGS_PS_COURSE type.
254: PROCEDURE respl_get_rsch_cty (
255: p_course_cd IGS_PS_VER.course_cd%TYPE,
256: p_version_number IGS_PS_VER.version_number%TYPE,
257: p_research_type_ind OUT NOCOPY VARCHAR2)
258: AS
259: BEGIN -- respl_get_rsch_cty

Line 256: p_version_number IGS_PS_VER.version_number%TYPE,

252: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
253: -- Local procedure used to get the research IGS_PS_COURSE type.
254: PROCEDURE respl_get_rsch_cty (
255: p_course_cd IGS_PS_VER.course_cd%TYPE,
256: p_version_number IGS_PS_VER.version_number%TYPE,
257: p_research_type_ind OUT NOCOPY VARCHAR2)
258: AS
259: BEGIN -- respl_get_rsch_cty
260: -- Determine if IGS_PS_COURSE version is a research IGS_PS_COURSE type,

Line 266: FROM IGS_PS_VER crv,

262: -- commencement date.
263: DECLARE
264: CURSOR c_crv IS
265: SELECT cty.research_type_ind
266: FROM IGS_PS_VER crv,
267: IGS_PS_TYPE cty
268: WHERE crv.course_cd = p_course_cd AND
269: crv.version_number = p_version_number AND
270: crv.course_type = cty.course_type;

Line 627: IGS_PS_VER crv

623: CURSOR c_sca IS
624: SELECT sca.attendance_type,
625: sca.commencement_dt
626: FROM IGS_EN_STDNT_PS_ATT sca,
627: IGS_PS_VER crv
628: WHERE sca.person_id = p_person_id AND
629: sca.course_cd = p_course_cd;
630: CURSOR c_cah1 (
631: cp_effective_start_dt DATE,