DBA Data[Home] [Help]

APPS.IGS_EN_TIMESLOTS dependencies on IGS_CA_TYPE

Line 367: FROM igs_ca_type

363: p_gpa OUT NOCOPY NUMBER) AS
364:
365: CURSOR c_chk_cal_cat IS
366: SELECT s_cal_cat
367: FROM igs_ca_type
368: WHERE cal_type = p_cal_type;
369: l_chk_cal_cat igs_ca_type.s_cal_cat%TYPE;
370:
371: CURSOR c_teach_to_load IS

Line 369: l_chk_cal_cat igs_ca_type.s_cal_cat%TYPE;

365: CURSOR c_chk_cal_cat IS
366: SELECT s_cal_cat
367: FROM igs_ca_type
368: WHERE cal_type = p_cal_type;
369: l_chk_cal_cat igs_ca_type.s_cal_cat%TYPE;
370:
371: CURSOR c_teach_to_load IS
372: SELECT load_cal_type, load_ci_sequence_number
373: FROM igs_ca_teach_to_load_v