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_018 dependencies on IGS_CA_INST_ALL

Line 502: -- replaced view igs_ca_inst with igs_ca_inst_all for perf bug#4961316

498: AND unit_attempt_status IN ('ENROLLED','UNCONFIRM','WAITLISTED');
499:
500:
501: --Retrieves the interface records with invalid teach alt codes
502: -- replaced view igs_ca_inst with igs_ca_inst_all for perf bug#4961316
503: CURSOR c_invalid_teach (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
504: SELECT sui.upload_id, sui.alternate_cd alt_cd
505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal
506: WHERE sui.batch_id=cp_batch_id

Line 505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal

501: --Retrieves the interface records with invalid teach alt codes
502: -- replaced view igs_ca_inst with igs_ca_inst_all for perf bug#4961316
503: CURSOR c_invalid_teach (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS
504: SELECT sui.upload_id, sui.alternate_cd alt_cd
505: FROM igs_en_blk_sua_ints sui,igs_ca_inst_all cal
506: WHERE sui.batch_id=cp_batch_id
507: AND status_flag IN ('U','R')
508: AND cal.alternate_code(+)=sui.alternate_cd
509: AND cal.alternate_code IS NULL;