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_RU_GEN_001 dependencies on IGS_PE_PRSID_GRP_MEM

Line 3026: FROM igs_pe_persid_group peg,igs_pe_prsid_grp_mem pegm

3022: l_tds r_tds ;
3023:
3024: CURSOR c_persid IS
3025: SELECT peg.group_cd
3026: FROM igs_pe_persid_group peg,igs_pe_prsid_grp_mem pegm
3027: WHERE peg.group_id = pegm.group_id
3028: AND pegm.person_id = p_person_id ;
3029:
3030: BEGIN

Line 4469: CURSOR CUR_PID IS SELECT G.GROUP_CD, PERSON_ID from IGS_PE_PRSID_GRP_MEM M, IGS_PE_PERSID_GROUP G WHERE

4465: WHERE pv.course_cd = pa.course_cd and pv.version_number = pa.version_number and pa.person_id = p_person_id and pa.course_cd = p_course_cd;
4466:
4467:
4468: -- CURSOR TO SELECT THE PERSON id GROUPS TO WHICH THE STUDENT BELONGS
4469: CURSOR CUR_PID IS SELECT G.GROUP_CD, PERSON_ID from IGS_PE_PRSID_GRP_MEM M, IGS_PE_PERSID_GROUP G WHERE
4470: G.GROUP_ID = M.GROUP_ID AND SYSDATE BETWEEN M.START_DATE AND NVL(M.END_DATE, SYSDATE+1)
4471: AND M.PERSON_ID = P_PERSON_ID ;
4472:
4473: --Cursor to get all the unit sets attempted by the student