DBA Data[Home] [Help]

APPS.IGS_FI_GEN_APINT dependencies on IGS_CA_INST_ALL

Line 110: CURSOR cur_cal_type (cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,

106: l_v_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE := p_v_location_cd;
107: l_v_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE := p_v_unit_class;
108:
109: --Cursor to get the Teaching Calendar for the Calendar Type and Calendar Instance Sequence Number.
110: CURSOR cur_cal_type (cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
111: cp_n_seq_number igs_ca_inst_all.sequence_number%TYPE
112: ) IS
113: SELECT alternate_code
114: FROM igs_ca_inst

Line 111: cp_n_seq_number igs_ca_inst_all.sequence_number%TYPE

107: l_v_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE := p_v_unit_class;
108:
109: --Cursor to get the Teaching Calendar for the Calendar Type and Calendar Instance Sequence Number.
110: CURSOR cur_cal_type (cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
111: cp_n_seq_number igs_ca_inst_all.sequence_number%TYPE
112: ) IS
113: SELECT alternate_code
114: FROM igs_ca_inst
115: WHERE cal_type = cp_v_cal_type