DBA Data[Home] [Help]

APPS.IGS_FI_WAV_UTILS_001 dependencies on IGS_FI_CR_TYPES

Line 175: igs_fi_cr_types_all cr

171: CURSOR chgadj_amt_cur (cp_n_invoice_id igs_fi_applications.invoice_id%TYPE) IS
172: SELECT appl.amount_applied
173: FROM igs_fi_applications appl,
174: igs_fi_credits_all crd,
175: igs_fi_cr_types_all cr
176: WHERE appl.invoice_id = cp_n_invoice_id
177: AND appl.credit_id = crd.credit_id
178: AND appl.application_type = 'APP'
179: AND crd.credit_type_id = cr.credit_type_id

Line 199: igs_fi_cr_types cr

195: appl.invoice_id
196: FROM igs_fi_inv_int_all inv,
197: igs_fi_applications appl,
198: igs_fi_credits_all crd,
199: igs_fi_cr_types cr
200: WHERE inv.person_id = cp_n_person_id
201: AND inv.fee_type = cp_v_target_fee_type
202: AND inv.fee_cal_type = cp_v_fee_cal_type
203: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 1235: igs_fi_cr_types cr

1231: appl.credit_id,
1232: appl.invoice_id
1233: FROM igs_fi_applications appl,
1234: igs_fi_credits_all crd,
1235: igs_fi_cr_types cr
1236: WHERE appl.invoice_id = cp_n_invoice_id
1237: AND appl.credit_id = crd.credit_id
1238: AND appl.application_type = cp_cst_app
1239: AND crd.credit_type_id = cr.credit_type_id