APPS.IGS_FI_PRC_IMPCLC_ANC_CHGS dependencies on IGS_FI_INV_INT

Line 415: l_diff_amount igs_fi_inv_int.invoice_amount_due%TYPE;

411: l_message VARCHAR2(2000);
412: l_person_number igs_pe_person.person_number%TYPE;
413:
414: -- Variables of type NUMBER
415: l_diff_amount igs_fi_inv_int.invoice_amount_due%TYPE;
416: l_import_charges_id igs_fi_imp_chgs.import_charges_id%TYPE;
417: l_impchgs_lines_id igs_fi_impchgs_lines.impchg_lines_id%TYPE;
418: l_ancillary_chg_rate igs_fi_anc_rates.ancillary_chg_rate%TYPE;
419: l_rec_cntr NUMBER(10);

Line 436: l_invoice_id igs_fi_inv_int.Invoice_Id%TYPE;

432: l_header_rec igs_fi_charges_api_pvt.header_rec_type;
433: l_line_tbl igs_fi_charges_api_pvt.line_tbl_type;
434: l_line_tbl_dummy igs_fi_charges_api_pvt.line_tbl_type;
435: l_line_id_tbl igs_fi_charges_api_pvt.line_id_tbl_type;
436: l_invoice_id igs_fi_inv_int.Invoice_Id%TYPE;
437: l_msg_count NUMBER(3);
438: l_msg_data VARCHAR2(2000);
439: l_return_status VARCHAR2(1);
440: l_prev_amount igs_fi_inv_int.invoice_amount%TYPE;

Line 440: l_prev_amount igs_fi_inv_int.invoice_amount%TYPE;

436: l_invoice_id igs_fi_inv_int.Invoice_Id%TYPE;
437: l_msg_count NUMBER(3);
438: l_msg_data VARCHAR2(2000);
439: l_return_status VARCHAR2(1);
440: l_prev_amount igs_fi_inv_int.invoice_amount%TYPE;
441: l_var NUMBER(3);
442: l_fee_desc igs_fi_fee_type.description%TYPE;
443:
444: l_v_local_currency igs_fi_control.currency_cd%TYPE;

Line 513: FROM igs_fi_inv_int inv

509: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
510: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
511: cp_transaction_type VARCHAR2) IS
512: SELECT SUM(invoice_amount)
513: FROM igs_fi_inv_int inv
514: WHERE inv.person_id = cp_person_id
515: AND inv.fee_cal_type = cp_fee_cal_type
516: AND inv.fee_ci_sequence_number = cp_fee_ci_sequence_number
517: AND inv.fee_type = cp_fee_type