APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_SCH_PRG_CFIG

Line 3982: CURSOR cur_config (cp_teaching_calendar_type IN igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE) IS

3978: Who When What
3979: (reverse chronological order - newest change first)
3980: ************************************************************************/
3981:
3982: CURSOR cur_config (cp_teaching_calendar_type IN igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE) IS
3983: SELECT purge_type
3984: FROM igs_ps_sch_prg_cfig
3985: WHERE teaching_calendar_type=cp_teaching_calendar_type;
3986: l_teaching_calendar_type igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE;

Line 3984: FROM igs_ps_sch_prg_cfig

3980: ************************************************************************/
3981:
3982: CURSOR cur_config (cp_teaching_calendar_type IN igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE) IS
3983: SELECT purge_type
3984: FROM igs_ps_sch_prg_cfig
3985: WHERE teaching_calendar_type=cp_teaching_calendar_type;
3986: l_teaching_calendar_type igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE;
3987:
3988: CURSOR cur_dates (cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 3986: l_teaching_calendar_type igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE;

3982: CURSOR cur_config (cp_teaching_calendar_type IN igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE) IS
3983: SELECT purge_type
3984: FROM igs_ps_sch_prg_cfig
3985: WHERE teaching_calendar_type=cp_teaching_calendar_type;
3986: l_teaching_calendar_type igs_ps_sch_prg_cfig.teaching_calendar_type%TYPE;
3987:
3988: CURSOR cur_dates (cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
3989: cp_sequence_number IN igs_ca_inst_all.sequence_number%TYPE) IS
3990: SELECT start_dt,end_dt