APPS.IGS_FI_VAL_FTCI dependencies on IGS_CA_STAT

Line 354: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

350: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
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

Line 377: IGS_CA_STAT cs

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
381: ci.CAL_STATUS = cs.CAL_STATUS;

Line 401: igs_ca_stat s

397: cp_load_cal_seq_num igs_ca_inst_all.sequence_number%TYPE)
398: IS
399: SELECT s.s_cal_status
400: FROM igs_ca_inst i,
401: igs_ca_stat s
402: WHERE s.cal_status = i.cal_status
403: AND i.cal_type = cp_load_cal_type
404: AND i.sequence_number = cp_load_cal_seq_num;
405: