DBA Data[Home] [Help]

APPS.IGS_FI_VAL_FRTNS dependencies on IGS_FI_CONTROL

Line 201: l_v_currency igs_fi_control.currency_cd%TYPE;

197: -- with a fee category currency set to other than the local
198: -- currency.
199: DECLARE
200:
201: l_v_currency igs_fi_control.currency_cd%TYPE;
202: v_fee_cat_currency_cd igs_fi_control.currency_cd%TYPE;
203:
204: CURSOR c_fc (cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE) IS
205: SELECT currency_cd

Line 202: v_fee_cat_currency_cd igs_fi_control.currency_cd%TYPE;

198: -- currency.
199: DECLARE
200:
201: l_v_currency igs_fi_control.currency_cd%TYPE;
202: v_fee_cat_currency_cd igs_fi_control.currency_cd%TYPE;
203:
204: CURSOR c_fc (cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE) IS
205: SELECT currency_cd
206: FROM IGS_FI_FEE_CAT

Line 216: FROM igs_fi_control;

212: fee_ci_sequence_number = p_fee_ci_sequence_number AND
213: FEE_TYPE = p_fee_type;
214: CURSOR cur_ctrl IS
215: SELECT currency_cd
216: FROM igs_fi_control;
217: BEGIN
218: p_message_name := NULL;
219: -- check if the definition is at the Fee Type Calendar Instance level
220: IF (p_s_relation_type <> 'FTCI') THEN