APPS.IGS_FI_VAL_FAS dependencies on IGS_CA_DA_INST_V

Line 177: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

173: --when recording a manual fee assessment.
174: --Current date must be <= IGS_FI_F_CAT_FEE_LBL_V.retro_dt (if specified,
175: --may be null)
176: DECLARE
177: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
178: CURSOR c_fcflv IS
179: SELECT daiv.alias_val
180: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
181: IGS_CA_DA_INST_V daiv

Line 181: IGS_CA_DA_INST_V daiv

177: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
178: CURSOR c_fcflv IS
179: SELECT daiv.alias_val
180: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
181: IGS_CA_DA_INST_V daiv
182: WHERE
183: fcflv.fee_cal_type = p_fee_cal_type AND
184: fcflv.fee_ci_sequence_number = p_fee_ci_sequence_number AND
185: fcflv.fee_type = p_fee_type AND

Line 430: v_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;

426: -- This module validates the effective_dt when recording a manual fee
427: -- assessment, effective_dt must be between IGS_FI_F_CAT_FEE_LBL_V.start_dt
428: -- and IGS_FI_F_CAT_FEE_LBL_V.end_dt.
429: DECLARE
430: v_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
431: v_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
432: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
433: CURSOR c_daiv_sd IS
434: SELECT daiv.alias_val

Line 431: v_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;

427: -- assessment, effective_dt must be between IGS_FI_F_CAT_FEE_LBL_V.start_dt
428: -- and IGS_FI_F_CAT_FEE_LBL_V.end_dt.
429: DECLARE
430: v_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
431: v_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
432: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
433: CURSOR c_daiv_sd IS
434: SELECT daiv.alias_val
435: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,

Line 436: IGS_CA_DA_INST_V daiv

432: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
433: CURSOR c_daiv_sd IS
434: SELECT daiv.alias_val
435: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
436: IGS_CA_DA_INST_V daiv
437: WHERE fcflv.fee_cal_type = p_fee_cal_type AND
438: fcflv.fee_ci_sequence_number = p_fee_ci_sequence_number AND
439: fcflv.fee_type = p_fee_type AND
440: fcflv.fee_cat = nvl(p_fee_cat,fcflv.fee_cat) AND

Line 448: IGS_CA_DA_INST_V daiv

444: fcflv.fee_ci_sequence_number = daiv.ci_sequence_number;
445: CURSOR c_daiv_ed IS
446: SELECT daiv.alias_val
447: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
448: IGS_CA_DA_INST_V daiv
449: WHERE fcflv.fee_cal_type = p_fee_cal_type AND
450: fcflv.fee_ci_sequence_number = p_fee_ci_sequence_number AND
451: fcflv.fee_type = p_fee_type AND
452: fcflv.fee_cat = nvl(p_fee_cat,fcflv.fee_cat) AND