DBA Data[Home] [Help]

APPS.IGS_FI_PAYMENT_PLANS dependencies on IGS_FI_F_TYP_CA_INST

Line 136: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

132: ORDER BY due_date;
133:
134: --Cursor to validate if the Fee Type and Fee Calendar Instance combination is an active combination.
135: CURSOR cur_validate_ftci(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
136: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
137: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
138: SELECT 'x'
139: FROM igs_fi_f_typ_ca_inst ftci,
140: igs_fi_fee_str_stat fst

Line 137: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

133:
134: --Cursor to validate if the Fee Type and Fee Calendar Instance combination is an active combination.
135: CURSOR cur_validate_ftci(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
136: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
137: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
138: SELECT 'x'
139: FROM igs_fi_f_typ_ca_inst ftci,
140: igs_fi_fee_str_stat fst
141: WHERE ftci.fee_type = cp_v_fee_type

Line 139: FROM igs_fi_f_typ_ca_inst ftci,

135: CURSOR cur_validate_ftci(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
136: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
137: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
138: SELECT 'x'
139: FROM igs_fi_f_typ_ca_inst ftci,
140: igs_fi_fee_str_stat fst
141: WHERE ftci.fee_type = cp_v_fee_type
142: AND ftci.fee_cal_type = cp_v_fee_cal_type
143: AND ftci.fee_ci_sequence_number = cp_n_fee_ci_seq_number