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_HE_PROG_TRANSFER_PKG dependencies on IGS_PS_GRP_MBR

Line 255: FROM igs_ps_grp_type a, igs_ps_grp_all b, igs_ps_grp_mbr c , igs_ps_grp_mbr d

251: -- smaddali added this cursor for Bug# 2717755
252: -- check if the old and new programs belong to the same program group with system group type CONTINUOUS
253: CURSOR c_prg_grp IS
254: SELECT b.course_group_cd
255: FROM igs_ps_grp_type a, igs_ps_grp_all b, igs_ps_grp_mbr c , igs_ps_grp_mbr d
256: WHERE a.course_group_type = b.course_group_type AND
257: a.closed_ind = 'N' AND
258: a.s_course_group_type = 'CONTINUOUS' AND
259: b.course_group_cd = c.course_group_cd AND

Line 860: FROM igs_ps_grp_type a, igs_ps_grp_all b, igs_ps_grp_mbr c , igs_ps_grp_mbr d

856: -- smaddali added this cursor for Bug# 2717755
857: -- check if the old and new programs belong to the same program group with system group type CONTINUOUS
858: CURSOR c_prg_grp IS
859: SELECT b.course_group_cd
860: FROM igs_ps_grp_type a, igs_ps_grp_all b, igs_ps_grp_mbr c , igs_ps_grp_mbr d
861: WHERE a.course_group_type = b.course_group_type AND
862: a.closed_ind = 'N' AND
863: a.s_course_group_type = 'CONTINUOUS' AND
864: b.course_group_cd = c.course_group_cd AND