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_PR_CP_GPA dependencies on IGS_GE_REF_CD_TYPE

Line 176: igs_ge_ref_cd_type rct

172: IS
173: SELECT 'X'
174: FROM igs_av_unt_ref_cds urc,
175: igs_ge_ref_cd refcd,
176: igs_ge_ref_cd_type rct
177: WHERE urc.av_stnd_unit_id = p_av_stnd_unit_id
178: AND urc.reference_code_id = refcd.reference_code_id
179: AND refcd.reference_cd_type = rct.reference_cd_type
180: AND rct.s_reference_cd_type = 'STATS'

Line 194: igs_ge_ref_cd_type rct

190: IS
191: SELECT 'X'
192: FROM igs_av_unt_ref_cds urc,
193: igs_ge_ref_cd refcd,
194: igs_ge_ref_cd_type rct
195: WHERE urc.av_stnd_unit_id = p_av_stnd_unit_id
196: AND urc.reference_code_id = refcd.reference_code_id
197: AND refcd.reference_cd_type = rct.reference_cd_type
198: AND rct.s_reference_cd_type = 'STATS'

Line 218: igs_ge_ref_cd_type rct

214: IS
215: SELECT 'X'
216: FROM igs_av_unt_ref_cds urc,
217: igs_ge_ref_cd refcd,
218: igs_ge_ref_cd_type rct
219: WHERE urc.av_stnd_unit_id = p_av_stnd_unit_id
220: AND urc.reference_code_id = refcd.reference_code_id
221: AND refcd.reference_cd_type = rct.reference_cd_type
222: AND rct.s_reference_cd_type = 'STATS'

Line 235: igs_ge_ref_cd_type rct

231: IS
232: SELECT 'X'
233: FROM igs_av_unt_ref_cds urc,
234: igs_ge_ref_cd refcd,
235: igs_ge_ref_cd_type rct
236: WHERE urc.av_stnd_unit_id = p_av_stnd_unit_id
237: AND urc.reference_code_id = refcd.reference_code_id
238: AND refcd.reference_cd_type = rct.reference_cd_type
239: AND rct.s_reference_cd_type = 'STATS'

Line 633: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

629: p_org_unit_cd;
630:
631: CURSOR c_org_included IS
632: SELECT 'X'
633: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
634: WHERE urc.unit_cd = p_unit_cd
635: AND urc.version_number = p_unit_version_number
636: AND urc.reference_cd_type = rct.reference_cd_type
637: AND rct.s_reference_cd_type = 'STATS'

Line 647: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

643: AND ostr1.include_or_exclude = 'INCLUDE');
644:
645: CURSOR c_org_excluded IS
646: SELECT 'X'
647: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
648: WHERE urc.unit_cd = p_unit_cd
649: AND urc.version_number = p_unit_version_number
650: AND urc.reference_cd_type = rct.reference_cd_type
651: AND rct.s_reference_cd_type = 'STATS'

Line 666: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

662: WHERE INSTR.stat_type = p_stat_type;
663:
664: CURSOR c_inst_included IS
665: SELECT 'X'
666: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
667: WHERE urc.unit_cd = p_unit_cd
668: AND urc.version_number = p_unit_version_number
669: AND urc.reference_cd_type = rct.reference_cd_type
670: AND rct.s_reference_cd_type = 'STATS'

Line 679: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

675: AND instr1.include_or_exclude = 'INCLUDE');
676:
677: CURSOR c_inst_excluded IS
678: SELECT 'X'
679: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
680: WHERE urc.unit_cd = p_unit_cd
681: AND urc.version_number = p_unit_version_number
682: AND urc.reference_cd_type = rct.reference_cd_type
683: AND rct.s_reference_cd_type = 'STATS'

Line 2603: igs_ge_ref_cd_type rct

2599:
2600: CURSOR c_org_included IS
2601: SELECT 'X'
2602: FROM igs_as_sua_ref_cds urc,
2603: igs_ge_ref_cd_type rct
2604: WHERE urc.person_id = p_person_id
2605: AND urc.uoo_id = p_uoo_id
2606: AND urc.course_cd = p_course_cd
2607: AND urc.reference_cd_type = rct.reference_cd_type

Line 2621: FROM igs_as_sua_ref_cds urc, igs_ge_ref_cd_type rct

2617:
2618:
2619: CURSOR c_org_excluded IS
2620: SELECT 'X'
2621: FROM igs_as_sua_ref_cds urc, igs_ge_ref_cd_type rct
2622: WHERE urc.person_id = p_person_id
2623: AND urc.uoo_id = p_uoo_id
2624: AND urc.course_cd = p_course_cd
2625: AND urc.reference_cd_type = rct.reference_cd_type

Line 2642: FROM igs_as_sua_ref_cds urc, igs_ge_ref_cd_type rct

2638: WHERE INSTR.stat_type = p_stat_type;
2639:
2640: CURSOR c_inst_included IS
2641: SELECT 'X'
2642: FROM igs_as_sua_ref_cds urc, igs_ge_ref_cd_type rct
2643: WHERE urc.person_id = p_person_id
2644: AND urc.uoo_id = p_uoo_id
2645: AND urc.course_cd = p_course_cd
2646: AND urc.reference_cd_type = rct.reference_cd_type

Line 2658: FROM igs_as_sua_ref_cds src, igs_ge_ref_cd_type rct

2654:
2655:
2656: CURSOR c_inst_excluded IS
2657: SELECT 'X'
2658: FROM igs_as_sua_ref_cds src, igs_ge_ref_cd_type rct
2659: WHERE src.person_id = p_person_id
2660: AND src.uoo_id = p_uoo_id
2661: AND src.course_cd = p_course_cd
2662: AND src.reference_cd_type = rct.reference_cd_type