APPS.IGS_ST_GEN_001 dependencies on IGS_PS_GRP_TYPE

Line 549: IGS_PS_GRP_TYPE cgt

545: EXISTS (
546: SELECT 'X'
547: FROM IGS_PS_GRP_MBR cgm,
548: IGS_PS_GRP cgr,
549: IGS_PS_GRP_TYPE cgt
550: WHERE cgm.course_cd = p_course_cd AND
551: cgm.version_number = p_version_number AND
552: cgr.course_group_cd = cgm.course_group_cd AND
553: cgt.course_group_type = cgr.course_group_type AND

Line 594: IGS_PS_GRP_TYPE cgt

590: CURSOR c_cgm_cgr_cgt IS
591: SELECT 'X'
592: FROM IGS_PS_GRP_MBR cgm,
593: IGS_PS_GRP cgr,
594: IGS_PS_GRP_TYPE cgt
595: WHERE cgm.course_cd = p_course_cd AND
596: cgm.version_number = p_version_number AND
597: cgr.course_group_cd = cgm.course_group_cd AND
598: cgt.course_group_type = cgr.course_group_type AND

Line 715: IGS_PS_GRP_TYPE cgt

711: EXISTS (
712: SELECT 'x'
713: FROM IGS_PS_GRP_MBR cgm2,
714: IGS_PS_GRP cgp,
715: IGS_PS_GRP_TYPE cgt
716: WHERE cgm2.course_cd = p_transfer_course_cd AND
717: cgm2.version_number = p_trnsfr_version_number AND
718: cgm2.course_group_cd = cgm1.course_group_cd AND
719: cgm2.course_group_cd = cgp.course_group_cd AND