DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_PS_VER

Line 563: FROM igs_ps_ver crv,

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
565: WHERE crv.course_cd = p_course_cd AND
566: crv.version_number = p_version_number AND
567: crv.course_type = ct.course_type;

Line 1185: IGS_PS_VER crv,

1181: CURSOR c_sca IS
1182: SELECT sca.person_id,
1183: sca.course_cd
1184: FROM IGS_EN_STDNT_PS_ATT sca,
1185: IGS_PS_VER crv,
1186: IGS_PS_STAT cs
1187: WHERE sca.course_cd LIKE p_course_cd AND
1188: sca.cal_type = p_acad_cal_type AND
1189: sca.location_cd LIKE p_location_cd AND

Line 1294: IGS_PS_VER crv,

1290: acai.nominated_course_cd,
1291: acai.sequence_number
1292: FROM IGS_AD_PS_APPL_INST acai,
1293: IGS_AD_APPL aa,
1294: IGS_PS_VER crv,
1295: IGS_PS_STAT cs
1296: WHERE
1297: acai.course_cd LIKE p_course_cd AND
1298: acai.location_cd LIKE p_location_cd AND