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_017 dependencies on IGS_CA_TYPE

Line 561: igs_ca_type ct,

557: CURSOR c_cur_alt_code IS
558: SELECT currterm.alternate_code
559: FROM (SELECT ci.alternate_code
560: FROM igs_ca_inst ci,
561: igs_ca_type ct,
562: igs_ca_stat cs,
563: igs_ca_da_inst dai
564: WHERE ci.cal_type = ct.cal_type
565: AND ct.s_cal_cat = 'LOAD'

Line 717: igs_ca_type ca,

713:
714: CURSOR c_alt_code IS
715: SELECT ci.alternate_code
716: FROM igs_ca_inst ci,
717: igs_ca_type ca,
718: igs_ca_stat cs
719: WHERE ci.cal_type =ca.cal_type
720: AND ci.cal_status = cs.cal_status
721: AND cs.s_cal_status = 'ACTIVE'

Line 1262: igs_ca_type ca,

1258: CURSOR c_alt_code IS
1259: SELECT ci.cal_type,
1260: ci.sequence_number
1261: FROM igs_ca_inst ci,
1262: igs_ca_type ca,
1263: igs_ca_stat cs
1264: WHERE ci.alternate_code = p_term_alt_code
1265: AND ci.cal_type = ca.cal_type
1266: AND ci.cal_status = cs.cal_status