APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_FI_INV_INT

Line 3741: FROM igs_fi_inv_int inv,

3737: CURSOR cur_inv_amt (cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
3738: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
3739: IS
3740: SELECT NVL(SUM(inv.invoice_amount),0) invoice_amount
3741: FROM igs_fi_inv_int inv,
3742: igs_fi_fee_type ft
3743: WHERE inv.fee_type = ft.fee_type
3744: AND person_id = p_person_id
3745: AND inv.fee_cal_type = cp_fee_cal_type

Line 3752: l_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;

3748:
3749: l_value igs_he_ex_rn_dat_fd.value%TYPE;
3750: l_slc_lea_cd igs_pe_alt_pers_id.api_person_id%TYPE;
3751: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
3752: l_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3753: l_tot_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3754: l_message_name fnd_new_messages.message_name%TYPE;
3755: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
3756: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 3753: l_tot_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;

3749: l_value igs_he_ex_rn_dat_fd.value%TYPE;
3750: l_slc_lea_cd igs_pe_alt_pers_id.api_person_id%TYPE;
3751: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
3752: l_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3753: l_tot_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3754: l_message_name fnd_new_messages.message_name%TYPE;
3755: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
3756: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3757: