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_PRC_LOAD dependencies on IGS_CA_STAT

Line 118: IGS_CA_STAT acs,

114: lci.sequence_number
115: FROM IGS_CA_INST_REL acir,
116: IGS_CA_INST aci,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,
120: IGS_CA_INST lci,
121: IGS_CA_TYPE lcat,
122: IGS_CA_STAT lcs

Line 122: IGS_CA_STAT lcs

118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,
120: IGS_CA_INST lci,
121: IGS_CA_TYPE lcat,
122: IGS_CA_STAT lcs
123: WHERE acir.sub_cal_type = p_teach_cal_type AND
124: acir.sub_ci_sequence_number = p_teach_sequence_number AND
125: aci.cal_type = acir.sup_cal_type AND
126: aci.sequence_number = acir.sup_ci_sequence_number AND

Line 1077: IGS_CA_STAT CS

1073: CI.sequence_number
1074: FROM IGS_CA_INST_REL CIR,
1075: IGS_CA_INST CI,
1076: IGS_CA_TYPE CT,
1077: IGS_CA_STAT CS
1078: WHERE CT.closed_ind = 'N' AND
1079: CT.s_cal_cat = cst_teaching AND
1080: CS.s_cal_status = cst_active AND
1081: CI.cal_status = CS.cal_status AND