DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_PS_TYPE

Line 560: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE ;

556: p_version_number NUMBER
557: ) RETURN VARCHAR2 AS
558: BEGIN
559: DECLARE
560: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE ;
561: CURSOR c_crv_ct IS
562: SELECT ct.govt_course_type
563: FROM igs_ps_ver crv,
564: igs_ps_type ct

Line 564: igs_ps_type ct

560: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE ;
561: CURSOR c_crv_ct IS
562: SELECT ct.govt_course_type
563: FROM igs_ps_ver crv,
564: igs_ps_type ct
565: WHERE crv.course_cd = p_course_cd AND
566: crv.version_number = p_version_number AND
567: crv.course_type = ct.course_type;
568: BEGIN