DBA Data[Home] [Help]

APPS.IGS_FI_SS_CHARGES_API_PVT dependencies on IGS_FI_FEE_TYPE

Line 76: l_fee_desc IGS_FI_FEE_TYPE.description%TYPE DEFAULT NULL;

72: l_chg_rec IGS_FI_CHARGES_API_PVT.Header_Rec_Type;
73: l_chg_line_tbl IGS_FI_CHARGES_API_PVT.Line_Tbl_Type;
74: l_line_id_tbl IGS_FI_CHARGES_API_PVT.Line_Id_Tbl_Type;
75: l_chg_mtd IGS_FI_F_TYP_CA_INST.s_chg_method_type%TYPE DEFAULT NULL;
76: l_fee_desc IGS_FI_FEE_TYPE.description%TYPE DEFAULT NULL;
77:
78: CURSOR cur_chg IS SELECT s_chg_method_type FROM igs_fi_f_typ_ca_inst
79: WHERE fee_type =p_fee_type
80: AND fee_cal_type=p_fee_cal_type

Line 82: CURSOR cur_fee_desc IS SELECT description FROM igs_fi_fee_type

78: CURSOR cur_chg IS SELECT s_chg_method_type FROM igs_fi_f_typ_ca_inst
79: WHERE fee_type =p_fee_type
80: AND fee_cal_type=p_fee_cal_type
81: AND fee_ci_sequence_number =p_fee_ci_sequence_number;
82: CURSOR cur_fee_desc IS SELECT description FROM igs_fi_fee_type
83: WHERE fee_type = p_fee_type;
84:
85: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
86: SELECT inv.*