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_AV_UNT_REF_CDS

Line 174: FROM igs_av_unt_ref_cds urc,

170:
171: CURSOR c_org_included
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

Line 192: FROM igs_av_unt_ref_cds urc,

188:
189: CURSOR c_org_excluded
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

Line 216: FROM igs_av_unt_ref_cds urc,

212:
213: CURSOR c_inst_included
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

Line 233: FROM igs_av_unt_ref_cds urc,

229:
230: CURSOR c_inst_excluded
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