APPS.IGS_PT_GEN_PKG dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 53: igs_ca_load_to_teach_v where load_cal_type = p_load_cal_type

49: AND unit_attempt_status = 'ENROLLED'
50: AND (cal_type,ci_sequence_number) IN
51: (
52: SELECT teach_cal_type,teach_ci_sequence_number FROM
53: igs_ca_load_to_teach_v where load_cal_type = p_load_cal_type
54: AND load_ci_sequence_number = p_load_sequence_number
55: )
56: AND rownum <= p_num_units
57: ORDER BY unit_cd;

Line 70: igs_ca_load_to_teach_v where load_cal_type = p_load_cal_type

66: AND unit_attempt_status = 'ENROLLED'
67: AND (cal_type,ci_sequence_number) IN
68: (
69: SELECT teach_cal_type,teach_ci_sequence_number FROM
70: igs_ca_load_to_teach_v where load_cal_type = p_load_cal_type
71: AND load_ci_sequence_number = p_load_sequence_number
72: )
73: AND course_cd IN (
74: SELECT course_cd FROM igs_en_stdnt_ps_att