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_EN_GEN_010 dependencies on IGS_PS_US_PRENR_CFG

Line 554: CURSOR c_next_us(cp_unit_set_cd igs_ps_us_prenr_cfg.unit_set_cd%TYPE) IS

550: usc.s_unit_set_cat = 'PRENRL_YR' ;
551: c_active_us_rec c_active_us%ROWTYPE;
552:
553: --get the next unit set in sequence
554: CURSOR c_next_us(cp_unit_set_cd igs_ps_us_prenr_cfg.unit_set_cd%TYPE) IS
555: SELECT cf1.unit_set_cd , cf1.sequence_no
556: FROM igs_ps_us_prenr_cfg cf1 , igs_ps_us_prenr_cfg cf2
557: WHERE cf2.mapping_set_cd = cf1.mapping_set_cd AND
558: cf2.unit_set_cd = cp_unit_set_cd AND

Line 556: FROM igs_ps_us_prenr_cfg cf1 , igs_ps_us_prenr_cfg cf2

552:
553: --get the next unit set in sequence
554: CURSOR c_next_us(cp_unit_set_cd igs_ps_us_prenr_cfg.unit_set_cd%TYPE) IS
555: SELECT cf1.unit_set_cd , cf1.sequence_no
556: FROM igs_ps_us_prenr_cfg cf1 , igs_ps_us_prenr_cfg cf2
557: WHERE cf2.mapping_set_cd = cf1.mapping_set_cd AND
558: cf2.unit_set_cd = cp_unit_set_cd AND
559: cf1.sequence_no > cf2.sequence_no
560: ORDER BY cf1.sequence_no asc;

Line 591: FROM igs_ps_us_prenr_cfg a

587: coou.attendance_type = v_acaiv_rec.attendance_type AND
588: coou.unit_set_cat = usc.unit_set_cat AND
589: usc.s_unit_set_cat = 'PRENRL_YR' AND
590: coou.unit_set_cd IN ( SELECT a.unit_set_cd
591: FROM igs_ps_us_prenr_cfg a
592: WHERE a.sequence_no = 1 );
593:
594: l_first_us c_first_us%ROWTYPE ;
595: l_us_cat VARCHAR2(1);

Line 4275: CURSOR c_next_us(cp_unit_set_cd igs_ps_us_prenr_cfg.unit_set_cd%TYPE) IS

4271: usc.s_unit_set_cat = 'PRENRL_YR' ;
4272: c_active_us_rec c_active_us%ROWTYPE;
4273:
4274: --get the next unit set in sequence
4275: CURSOR c_next_us(cp_unit_set_cd igs_ps_us_prenr_cfg.unit_set_cd%TYPE) IS
4276: SELECT cf1.unit_set_cd , cf1.sequence_no
4277: FROM igs_ps_us_prenr_cfg cf1 , igs_ps_us_prenr_cfg cf2
4278: WHERE cf2.mapping_set_cd = cf1.mapping_set_cd AND
4279: cf2.unit_set_cd = cp_unit_set_cd AND

Line 4277: FROM igs_ps_us_prenr_cfg cf1 , igs_ps_us_prenr_cfg cf2

4273:
4274: --get the next unit set in sequence
4275: CURSOR c_next_us(cp_unit_set_cd igs_ps_us_prenr_cfg.unit_set_cd%TYPE) IS
4276: SELECT cf1.unit_set_cd , cf1.sequence_no
4277: FROM igs_ps_us_prenr_cfg cf1 , igs_ps_us_prenr_cfg cf2
4278: WHERE cf2.mapping_set_cd = cf1.mapping_set_cd AND
4279: cf2.unit_set_cd = cp_unit_set_cd AND
4280: cf1.sequence_no > cf2.sequence_no
4281: ORDER BY cf1.sequence_no asc;

Line 7947: igs_ps_us_prenr_cfg upc

7943: ------------------------------------------------------------------------------------------------
7944: CURSOR c_acad_us (cp_new_admin_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE) IS
7945: SELECT usm.stream_unit_set_Cd
7946: FROM igs_en_unit_set_map usm,
7947: igs_ps_us_prenr_cfg upc
7948: WHERE upc.unit_set_cd = cp_new_admin_unit_set_cd
7949: AND usm.mapping_set_cd = upc.mapping_set_cd
7950: AND usm.sequence_no = upc.sequence_no;
7951:

Line 8450: igs_ps_us_prenr_cfg upc

8446:
8447: CURSOR c_acad_us (cp_old_admin_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE) IS
8448: SELECT usm.stream_unit_set_Cd
8449: FROM igs_en_unit_set_map usm,
8450: igs_ps_us_prenr_cfg upc
8451: WHERE upc.unit_set_cd = cp_old_admin_unit_set_cd
8452: AND usm.mapping_set_cd = upc.mapping_set_cd
8453: AND usm.sequence_no = upc.sequence_no;
8454: