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_PS_GEN_008 dependencies on IGS_CA_INST_REL

Line 2970: igs_ca_inst_rel cir

2966: SELECT ci.cal_type,
2967: ci.sequence_number
2968: FROM igs_ca_type ct,
2969: igs_ca_inst ci,
2970: igs_ca_inst_rel cir
2971: WHERE cir.sup_ci_sequence_number = ci.sequence_number
2972: AND cir.sup_cal_type = ci.cal_type
2973: AND ct.cal_type = ci.cal_type
2974: AND ct.s_cal_cat = cst_exam

Line 2988: IGS_CA_INST_REL cir

2984: cp_teach_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2985: SELECT COUNT(ci.cal_type)
2986: FROM IGS_CA_TYPE ct,
2987: IGS_CA_INST ci,
2988: IGS_CA_INST_REL cir
2989: WHERE cir.sup_ci_sequence_number = ci.sequence_number
2990: AND cir.sup_cal_type = ci.cal_type
2991: AND ct.cal_type = ci.cal_type
2992: AND ct.s_cal_cat = cst_exam