APPS.IGS_CA_GEN_001 dependencies on IGS_CA_INST_REL

Line 316: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE DEFAULT NULL;

312: -- Return the superior calendar instance for a given calendar type and
313: -- subordinate calendar instance.
314: DECLARE
315: v_sup_ci_sequence_number
316: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE DEFAULT NULL;
317: CURSOR c_cir IS
318: SELECT sup_ci_sequence_number
319: FROM IGS_CA_INST_REL
320: WHERE sub_cal_type = p_sub_cal_type AND

Line 319: FROM IGS_CA_INST_REL

315: v_sup_ci_sequence_number
316: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE DEFAULT NULL;
317: CURSOR c_cir IS
318: SELECT sup_ci_sequence_number
319: FROM IGS_CA_INST_REL
320: WHERE sub_cal_type = p_sub_cal_type AND
321: sub_ci_sequence_number = p_sub_ci_sequence_number AND
322: sup_cal_type = p_sup_cal_type;
323: BEGIN