APPS.IGS_PS_GEN_001 dependencies on IGS_CA_INST_ALL

Line 2348: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS

2344: AND ct.s_cal_cat = 'FEE'
2345: AND ci.cal_status = cs.cal_status
2346: AND cs.s_cal_status = 'ACTIVE';
2347:
2348: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2349: SELECT start_dt,end_dt
2350: FROM igs_ca_inst_all
2351: WHERE cal_type = cp_cal_type
2352: AND sequence_number = cp_seq_num;

Line 2350: FROM igs_ca_inst_all

2346: AND cs.s_cal_status = 'ACTIVE';
2347:
2348: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2349: SELECT start_dt,end_dt
2350: FROM igs_ca_inst_all
2351: WHERE cal_type = cp_cal_type
2352: AND sequence_number = cp_seq_num;
2353:
2354: l_d_src_teach_cal_start_dt DATE;

Line 2403: cal_type igs_ca_inst_all.cal_type%TYPE,

2399: FROM igs_ca_teach_to_load_v
2400: WHERE teach_cal_type = cp_c_cal_type
2401: AND teach_ci_sequence_number = cp_n_sequence_number);
2402: TYPE teach_cal_rec IS RECORD(
2403: cal_type igs_ca_inst_all.cal_type%TYPE,
2404: sequence_number igs_ca_inst_all.sequence_number%TYPE
2405: );
2406: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
2407: teachCalendar_tbl teachCalendar;

Line 2404: sequence_number igs_ca_inst_all.sequence_number%TYPE

2400: WHERE teach_cal_type = cp_c_cal_type
2401: AND teach_ci_sequence_number = cp_n_sequence_number);
2402: TYPE teach_cal_rec IS RECORD(
2403: cal_type igs_ca_inst_all.cal_type%TYPE,
2404: sequence_number igs_ca_inst_all.sequence_number%TYPE
2405: );
2406: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
2407: teachCalendar_tbl teachCalendar;
2408: l_n_counter NUMBER(10);