eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_ST_GEN_001 dependencies on IGS_PS_GRP

Line 538: v_course_equivalance_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;

534: p_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
535: RETURN BOOLEAN AS
536: BEGIN
537: DECLARE
538: v_course_equivalance_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;
539: v_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;
540: CURSOR c_cgm IS
541: SELECT 'X'
542: FROM IGS_PS_GRP_MBR cgm1

Line 539: v_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;

535: RETURN BOOLEAN AS
536: BEGIN
537: DECLARE
538: v_course_equivalance_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;
539: v_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;
540: CURSOR c_cgm IS
541: SELECT 'X'
542: FROM IGS_PS_GRP_MBR cgm1
543: WHERE cgm1.course_cd = p_prev_course_cd AND

Line 542: FROM IGS_PS_GRP_MBR cgm1

538: v_course_equivalance_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;
539: v_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;
540: CURSOR c_cgm IS
541: SELECT 'X'
542: FROM IGS_PS_GRP_MBR cgm1
543: WHERE cgm1.course_cd = p_prev_course_cd AND
544: cgm1.version_number = p_prev_version_number AND
545: EXISTS (
546: SELECT 'X'

Line 547: FROM IGS_PS_GRP_MBR cgm,

543: WHERE cgm1.course_cd = p_prev_course_cd AND
544: cgm1.version_number = p_prev_version_number AND
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

Line 548: IGS_PS_GRP cgr,

544: cgm1.version_number = p_prev_version_number AND
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

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 592: FROM IGS_PS_GRP_MBR cgm,

588: DECLARE
589: v_cgm_cgr_cgt_exists VARCHAR2(1);
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

Line 593: IGS_PS_GRP cgr,

589: v_cgm_cgr_cgt_exists VARCHAR2(1);
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

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 708: FROM IGS_PS_GRP_MBR cgm1

704: sct.course_cd = p_course_cd AND
705: sct.transfer_course_cd = p_transfer_course_cd;
706: CURSOR c_cgm IS
707: SELECT 'x'
708: FROM IGS_PS_GRP_MBR cgm1
709: WHERE cgm1.course_cd = p_course_cd AND
710: cgm1.version_number = p_version_number AND
711: EXISTS (
712: SELECT 'x'

Line 713: FROM IGS_PS_GRP_MBR cgm2,

709: WHERE cgm1.course_cd = p_course_cd AND
710: cgm1.version_number = p_version_number AND
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

Line 714: IGS_PS_GRP cgp,

710: cgm1.version_number = p_version_number AND
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

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