APPS.IGS_ST_GEN_002 dependencies on IGS_PS_VER

Line 33: FROM IGS_PS_VER cv,

29: DECLARE
30: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
31: CURSOR c_cty IS
32: SELECT cty.govt_course_type
33: FROM IGS_PS_VER cv,
34: IGS_PS_TYPE cty
35: WHERE cv.course_cd = p_course_cd AND
36: cv.version_number = p_version_number AND
37: cty.course_type = cv.course_type;

Line 90: p_course_cd IGS_PS_VER_ALL.course_cd%TYPE ,

86: END;
87: END stap_get_course_lvl;
88:
89: Procedure Stap_Get_Crs_Study(
90: p_course_cd IGS_PS_VER_ALL.course_cd%TYPE ,
91: p_version_number IGS_PS_VER_ALL.version_number%TYPE ,
92: p_reference_cd OUT NOCOPY IGS_PS_REF_CD.reference_cd%TYPE ,
93: p_description OUT NOCOPY IGS_PS_VER_ALL.title%TYPE )
94: AS

Line 91: p_version_number IGS_PS_VER_ALL.version_number%TYPE ,

87: END stap_get_course_lvl;
88:
89: Procedure Stap_Get_Crs_Study(
90: p_course_cd IGS_PS_VER_ALL.course_cd%TYPE ,
91: p_version_number IGS_PS_VER_ALL.version_number%TYPE ,
92: p_reference_cd OUT NOCOPY IGS_PS_REF_CD.reference_cd%TYPE ,
93: p_description OUT NOCOPY IGS_PS_VER_ALL.title%TYPE )
94: AS
95: gv_other_detail VARCHAR2(255);

Line 93: p_description OUT NOCOPY IGS_PS_VER_ALL.title%TYPE )

89: Procedure Stap_Get_Crs_Study(
90: p_course_cd IGS_PS_VER_ALL.course_cd%TYPE ,
91: p_version_number IGS_PS_VER_ALL.version_number%TYPE ,
92: p_reference_cd OUT NOCOPY IGS_PS_REF_CD.reference_cd%TYPE ,
93: p_description OUT NOCOPY IGS_PS_VER_ALL.title%TYPE )
94: AS
95: gv_other_detail VARCHAR2(255);
96: BEGIN -- stap_get_crs_study
97: -- This module returns the course of study code and

Line 113: FROM IGS_PS_VER crv

109: rct.s_reference_cd_type = 'OTHER' AND
110: rct.closed_ind = 'N';
111: CURSOR c_crv IS
112: SELECT crv.title
113: FROM IGS_PS_VER crv
114: WHERE crv.course_cd = p_course_cd AND
115: crv.version_number = p_version_number;
116: BEGIN
117: p_reference_cd := NULL;