APPS.IGS_FI_GEN_008 dependencies on IGS_FI_TP_RET_SCHD_V

Line 411: FROM igs_fi_tp_ret_schd_v

407: cp_n_fee_ci_sequence_num igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
408: cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
409: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
410: SELECT *
411: FROM igs_fi_tp_ret_schd_v
412: WHERE teach_cal_type = cp_v_teach_cal_type
413: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
414: AND fee_cal_type = cp_v_fee_cal_type
415: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_num

Line 423: FROM igs_fi_tp_ret_schd_v

419: -- Cursor to fetch Retention Schedules defined at Teaching Period level
420: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
421: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
422: SELECT *
423: FROM igs_fi_tp_ret_schd_v
424: WHERE teach_cal_type = cp_v_teach_cal_type
425: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
426: AND fee_type IS NULL
427: AND fee_cal_type IS NULL

Line 667: FROM igs_fi_tp_ret_schd_v

663: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
664: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
665: cp_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE) IS
666: SELECT 'X'
667: FROM igs_fi_tp_ret_schd_v
668: WHERE teach_cal_type = cp_v_teach_cal_type
669: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
670: AND fee_type IS NULL
671: AND fee_cal_type IS NULL