[Home] [Help]
85: FROM IGS_CA_INST_REL cir
86: WHERE cir.sub_cal_type = p_fee_cal_type AND
87: cir.sub_ci_sequence_number = p_fee_ci_sequence_number AND
88: cir.sup_cal_type IN ( SELECT ct.CAL_TYPE
89: FROM IGS_CA_TYPE ct
90: WHERE ct.CAL_TYPE = cir.sup_cal_type AND
91: ct.S_CAL_CAT = cst_cal_cat AND
92: ct.closed_ind = 'N');
93: BEGIN
351: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;
352: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE;
353: v_acc_closed_ind IGS_FI_ACC.closed_ind%TYPE;
354: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
355: v_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;
356: CURSOR c_fss (
357: cp_fee_type_ci_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE) IS
358: SELECT fss.s_fee_structure_status
359: FROM IGS_FI_FEE_STR_STAT fss
372: CURSOR c_fee_ci IS
373: SELECT cs.s_cal_status,
374: ct.S_CAL_CAT
375: FROM IGS_CA_INST ci,
376: IGS_CA_TYPE ct,
377: IGS_CA_STAT cs
378: WHERE ci.CAL_TYPE = p_fee_cal_type AND
379: ci.sequence_number = p_fee_ci_sequence_number AND
380: ci.CAL_TYPE = ct.CAL_TYPE AND
383: -- Start of Modifications Enh# 2187247
384: -- Parameter to the function igs_fi_gen_001.finp_get_lfci_reln,
385: -- suggesting the input parameters are of FEE Calendar Category
386: -- OUT NOCOPY parameters are of LOAD Calendar Category
387: cst_fee CONSTANT igs_ca_type.s_cal_cat%TYPE :='FEE';
388:
389: -- Variables to storing Load Calendar Instance
390: l_c_load_cal_type igs_ca_inst_all.cal_type%TYPE;
391: l_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE;