APPS.IGS_FI_GEN_004 dependencies on IGS_FI_F_CAT_FEE_LBL_ALL

Line 946: CURSOR cur_wav_calc_flag ( cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,

942: l_v_include_audit VARCHAR2(1);
943: l_v_wav_calc_flag VARCHAR2(1);
944: l_n_waiver_amount NUMBER;
945:
946: CURSOR cur_wav_calc_flag ( cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
947: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
948: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
949: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
950: SELECT waiver_calc_flag

Line 947: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

943: l_v_wav_calc_flag VARCHAR2(1);
944: l_n_waiver_amount NUMBER;
945:
946: CURSOR cur_wav_calc_flag ( cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
947: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
948: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
949: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
950: SELECT waiver_calc_flag
951: FROM igs_fi_f_cat_fee_lbl_all

Line 948: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

944: l_n_waiver_amount NUMBER;
945:
946: CURSOR cur_wav_calc_flag ( cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
947: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
948: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
949: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
950: SELECT waiver_calc_flag
951: FROM igs_fi_f_cat_fee_lbl_all
952: WHERE fee_cat = cp_v_fee_cat OR cp_v_fee_cat IS NULL

Line 949: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS

945:
946: CURSOR cur_wav_calc_flag ( cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
947: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
948: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
949: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
950: SELECT waiver_calc_flag
951: FROM igs_fi_f_cat_fee_lbl_all
952: WHERE fee_cat = cp_v_fee_cat OR cp_v_fee_cat IS NULL
953: AND fee_cal_type = cp_v_fee_cal_type

Line 951: FROM igs_fi_f_cat_fee_lbl_all

947: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
948: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
949: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
950: SELECT waiver_calc_flag
951: FROM igs_fi_f_cat_fee_lbl_all
952: WHERE fee_cat = cp_v_fee_cat OR cp_v_fee_cat IS NULL
953: AND fee_cal_type = cp_v_fee_cal_type
954: AND fee_ci_sequence_number = cp_n_fee_ci_seq_num
955: AND fee_type = cp_v_fee_type;