199: DECLARE
200: --Cursor to fetch the currency code that is setup in System Options Form.
201: CURSOR cur_ctrl IS
202: SELECT currency_cd
203: FROM igs_fi_control;
204:
205: --Cursor to fetch the currency code value for a fee category
206: CURSOR c_fc (cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
207: SELECT currency_cd
220: fee_cal_type = cp_fee_cal_type AND
221: fee_ci_sequence_number = cp_fee_ci_seq_num AND
222: NVL(FEE_CAT, cp_fee_cat) = cp_fee_cat;
223:
224: v_currency_cd igs_fi_control.currency_cd%TYPE;
225: v_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE;
226: l_ctrl_currency igs_fi_control.currency_cd%TYPE;
227:
228: BEGIN
222: NVL(FEE_CAT, cp_fee_cat) = cp_fee_cat;
223:
224: v_currency_cd igs_fi_control.currency_cd%TYPE;
225: v_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE;
226: l_ctrl_currency igs_fi_control.currency_cd%TYPE;
227:
228: BEGIN
229: OPEN cur_ctrl;
230: FETCH cur_ctrl INTO l_ctrl_currency;
1544: /******************************************************************
1545: Created By : SYkrishn
1546: Date Created By : 02-APR-2002
1547: Purpose : This function is used to derive the value of Planned_credits_ind
1548: from the table IGS_FI_CONTROL- Return N if Null
1549: Enh # 2293676
1550: Known limitations,
1551: enhancements,
1552: remarks :
1556:
1557: --Cursor to get the planned credits indicator
1558: CURSOR c_pln_credits_ind IS
1559: SELECT planned_credits_ind
1560: FROM igs_fi_control;
1561:
1562: l_v_pln_credits_ind igs_fi_control_all.planned_credits_ind%TYPE;
1563:
1564: BEGIN
1558: CURSOR c_pln_credits_ind IS
1559: SELECT planned_credits_ind
1560: FROM igs_fi_control;
1561:
1562: l_v_pln_credits_ind igs_fi_control_all.planned_credits_ind%TYPE;
1563:
1564: BEGIN
1565: OPEN c_pln_credits_ind;
1566: FETCH c_pln_credits_ind INTO l_v_pln_credits_ind;