APPS.IGS_ST_GEN_002 dependencies on IGS_PS_REF_CD

Line 92: p_reference_cd OUT NOCOPY IGS_PS_REF_CD.reference_cd%TYPE ,

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);
96: BEGIN -- stap_get_crs_study

Line 104: FROM IGS_PS_REF_CD crfc,

100: DECLARE
101: CURSOR c_crfc_rct IS
102: SELECT crfc.reference_cd,
103: crfc.description
104: FROM IGS_PS_REF_CD crfc,
105: IGS_GE_REF_CD_TYPE rct
106: WHERE crfc.course_cd = p_course_cd AND
107: crfc.version_number = p_version_number AND
108: rct.reference_cd_type = crfc.reference_cd_type AND