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_SS_ENR_DETAILS dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 1655: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua

1651:
1652: --ijeddy modified the cursor for bug 3724930
1653: CURSOR c_term_info_ccd IS
1654: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_description
1655: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua
1656: WHERE ttl.teach_cal_type = sua.cal_type
1657: AND ttl.teach_ci_sequence_number = sua.ci_sequence_number
1658: AND sua.unit_attempt_status = 'ENROLLED'
1659: AND sua.person_id = p_person_id

Line 1666: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua

1662:
1663:
1664: CURSOR c_term_info IS
1665: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_description
1666: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua
1667: WHERE ttl.teach_cal_type = sua.cal_type
1668: AND ttl.teach_ci_sequence_number = sua.ci_sequence_number
1669: AND sua.unit_attempt_status = 'ENROLLED'
1670: AND sua.person_id = p_person_id

Line 4246: AND (sua.cal_type , sua.ci_sequence_number) in (select teach_cal_type, teach_ci_sequence_number from igs_ca_teach_to_load_v where

4242: FROM IGS_EN_SU_ATTEMPT sua
4243: WHERE sua.unit_attempt_status = 'UNCONFIRM'
4244: AND sua.person_id = p_personid
4245: AND sua.course_cd = p_course_cd
4246: AND (sua.cal_type , sua.ci_sequence_number) in (select teach_cal_type, teach_ci_sequence_number from igs_ca_teach_to_load_v where
4247: load_cal_type = cp_term_cal_type and load_ci_sequence_number = cp_term_seq_num);
4248:
4249: l_total_plan_credits NUMBER;
4250: l_total_unconfirm_credits NUMBER;

Line 5295: AND (sua.cal_type , sua.ci_sequence_number) in (select teach_cal_type, teach_ci_sequence_number from igs_ca_teach_to_load_v where

5291: FROM IGS_EN_SU_ATTEMPT sua
5292: WHERE sua.unit_attempt_status = 'UNCONFIRM'
5293: AND sua.person_id = p_personid
5294: AND sua.course_cd = p_course_cd
5295: AND (sua.cal_type , sua.ci_sequence_number) in (select teach_cal_type, teach_ci_sequence_number from igs_ca_teach_to_load_v where
5296: load_cal_type = cp_term_cal_type and load_ci_sequence_number = cp_term_seq_num)
5297: AND ss_source_ind <> 'S';
5298:
5299:

Line 5555: FROM igs_ca_teach_to_load_v

5551: AND sua.person_id = p_personid
5552: AND sua.course_cd = p_course_cd
5553: AND sua.ss_source_ind <> 'S'
5554: AND (sua.cal_type , sua.ci_sequence_number) in (SELECT teach_cal_type, teach_ci_sequence_number
5555: FROM igs_ca_teach_to_load_v
5556: WHERE load_cal_type = cp_term_cal_type
5557: AND load_ci_sequence_number = cp_term_seq_num);
5558:
5559: