APPS.IGS_FI_WAIVERS_API_PUB dependencies on IGS_FI_INV_INT_ALL

Line 122: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

118: l_n_conv_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
119: l_n_version_number igs_fi_balance_rules.version_number%TYPE;
120: l_n_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
121: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
122: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
123:
124: l_d_last_conversion_date DATE;
125:
126: l_b_return_status BOOLEAN;

Line 538: igs_fi_inv_int_all inv

534: cp_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE
535: ) IS
536: SELECT appl.amount_applied
537: FROM igs_fi_applications appl,
538: igs_fi_inv_int_all inv
539: WHERE appl.credit_id = cp_n_credit_id
540: AND appl.invoice_id = inv.invoice_id
541: AND appl.application_type = 'APP'
542: AND inv.fee_cal_type = cp_v_fee_cal_type