APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_CA_TYPE

Line 572: l_source_cal_cat igs_ca_type.s_cal_cat%TYPE ;

568: l_source_sequence_number igs_ca_inst.sequence_number%TYPE;
569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
570: l_source_start_date igs_ca_inst.start_dt%TYPE ;
571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;
572: l_source_cal_cat igs_ca_type.s_cal_cat%TYPE ;
573: l_dest_cal_cat igs_ca_type.s_cal_cat%TYPE ;
574: l_fac_wl_id igs_ps_fac_wl.fac_wl_id%TYPE DEFAULT NULL;
575:
576:

Line 573: l_dest_cal_cat igs_ca_type.s_cal_cat%TYPE ;

569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
570: l_source_start_date igs_ca_inst.start_dt%TYPE ;
571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;
572: l_source_cal_cat igs_ca_type.s_cal_cat%TYPE ;
573: l_dest_cal_cat igs_ca_type.s_cal_cat%TYPE ;
574: l_fac_wl_id igs_ps_fac_wl.fac_wl_id%TYPE DEFAULT NULL;
575:
576:
577: --get the calendar category for the passed calendar

Line 579: CURSOR cur_cal_cat(cp_cal_type igs_ca_type.cal_type%TYPE ) IS

575:
576:
577: --get the calendar category for the passed calendar
578: --
579: CURSOR cur_cal_cat(cp_cal_type igs_ca_type.cal_type%TYPE ) IS
580: SELECT s_cal_cat
581: FROM igs_ca_type
582: WHERE cal_type = cp_cal_type ;
583:

Line 581: FROM igs_ca_type

577: --get the calendar category for the passed calendar
578: --
579: CURSOR cur_cal_cat(cp_cal_type igs_ca_type.cal_type%TYPE ) IS
580: SELECT s_cal_cat
581: FROM igs_ca_type
582: WHERE cal_type = cp_cal_type ;
583:
584: --get all the faculty records
585: --