eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_VAL_FAS dependencies on IGS_FI_F_CAT_FEE_LBL_V

Line 174: --Current date must be <= IGS_FI_F_CAT_FEE_LBL_V.retro_dt (if specified,

170: gv_other_detail VARCHAR2(255);
171: BEGIN --finp_val_fas_retro
172: --validate the current date against any retrospective assessment period
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

Line 180: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,

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
182: WHERE
183: fcflv.fee_cal_type = p_fee_cal_type AND
184: fcflv.fee_ci_sequence_number = p_fee_ci_sequence_number AND

Line 427: -- assessment, effective_dt must be between IGS_FI_F_CAT_FEE_LBL_V.start_dt

423: RETURN BOOLEAN AS
424: gv_other_detail VARCHAR2(255);
425: BEGIN -- finp_val_fas_eff_dt
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;

Line 428: -- and IGS_FI_F_CAT_FEE_LBL_V.end_dt.

424: gv_other_detail VARCHAR2(255);
425: BEGIN -- finp_val_fas_eff_dt
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;

Line 435: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,

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,
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

Line 447: FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,

443: fcflv.fee_cal_type = daiv.cal_type AND
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