DBA Data[Home] [Help]

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 653: FROM igs_ca_teach_to_load_v

649:
650: CURSOR c_multiple_load(cp_cal_type IN VARCHAR2,
651: cp_seq_num IN NUMBER ) IS
652: SELECT COUNT(*)
653: FROM igs_ca_teach_to_load_v
654: WHERE teach_cal_type = cp_cal_type
655: AND teach_ci_sequence_number = cp_seq_num
656: AND rownum < 3;
657: l_deny_warn igs_en_cpd_ext.notification_flag%TYPE;

Line 1650: igs_ca_teach_to_load_v rel

1646: cp_n_seq_num IN NUMBER) IS
1647: SELECT sua.ROWID ROW_ID,
1648: sua.uoo_id
1649: FROM igs_en_su_attempt_all sua,
1650: igs_ca_teach_to_load_v rel
1651: WHERE sua.person_id = cp_n_person_id
1652: AND sua.course_cd = cp_c_program_code
1653: AND sua.cal_type = rel.teach_cal_type
1654: AND sua.ci_sequence_number = rel.teach_ci_sequence_number