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

Line 312: igs_ca_inst_rel carel

308: p_cal_type VARCHAR2,
309: p_sequence_number NUMBER) IS
310: SELECT sua.unit_cd,sua.version_number,sua.override_enrolled_cp,sua.uoo_id
311: FROM igs_en_su_attempt sua,
312: igs_ca_inst_rel carel
313: WHERE sua.person_id = p_person_id and
314: sua.unit_attempt_status = 'ENROLLED' and
315: ((sua.cal_type = p_cal_type and
316: sua.ci_sequence_number = p_sequence_number)OR

Line 1870: SELECT 'x' FROM igs_ca_inst_rel cir2

1866: p_teach_cal_type IN VARCHAR2,
1867: p_teach_seq_num IN NUMBER)
1868: RETURN VARCHAR2 AS
1869: CURSOR cur_find_rel IS
1870: SELECT 'x' FROM igs_ca_inst_rel cir2
1871: WHERE cir2.sup_cal_type = p_acad_cal_type
1872: AND cir2.sub_cal_type = p_teach_cal_type
1873: AND cir2.sub_ci_sequence_number = p_teach_seq_num;
1874: l_dummy VARCHAR2(1);

Line 1961: IGS_CA_INST_REL cir

1957: igs_ps_ver_all pv,
1958: igs_ps_type_all pt,
1959: IGS_AD_PS_APPL_INST_all acai,
1960: IGS_AD_APPL_all aav,
1961: IGS_CA_INST_REL cir
1962: WHERE pv.course_cd = sca.course_cd AND
1963: pv.version_number = sca.version_number AND
1964: sca.course_attempt_status IN ('INACTIVE','UNCONFIRM') AND
1965: pv.course_type = pt.course_type AND