DBA Data[Home] [Help]

APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_FI_WAV_PR_PREQS

Line 302: cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE) IS

298: AND crt.credit_class = 'CHGADJ';
299:
300: CURSOR cur_prewav(cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
301: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
302: cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE) IS
303: SELECT fwpp.sup_waiver_name
304: FROM igs_fi_wav_pr_preqs fwpp
305: WHERE fwpp.fee_cal_type = cp_v_fee_cal_type
306: AND fwpp.fee_ci_sequence_number = cp_n_fee_ci_seq

Line 304: FROM igs_fi_wav_pr_preqs fwpp

300: CURSOR cur_prewav(cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
301: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
302: cp_v_waiver_name igs_fi_wav_pr_preqs.sub_waiver_name%TYPE) IS
303: SELECT fwpp.sup_waiver_name
304: FROM igs_fi_wav_pr_preqs fwpp
305: WHERE fwpp.fee_cal_type = cp_v_fee_cal_type
306: AND fwpp.fee_ci_sequence_number = cp_n_fee_ci_seq
307: AND fwpp.sub_waiver_name = cp_v_waiver_name;
308: