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_PRC_FEE_ASS dependencies on IGS_CA_DA_INST_V

Line 282: FROM igs_ca_da_inst_v

278: CURSOR c_check_dt_alias (cp_dt_alias igs_ca_da_inst.dt_alias%TYPE,
279: cp_cal_type igs_ca_da_inst.cal_type%TYPE,
280: cp_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE) IS
281: SELECT MAX(alias_val)
282: FROM igs_ca_da_inst_v
283: WHERE dt_alias = cp_dt_alias
284: AND cal_type = cp_cal_type
285: AND ci_sequence_number = cp_ci_sequence_number;
286:

Line 288: l_d_check_dt_alias igs_ca_da_inst_v.alias_val%TYPE;

284: AND cal_type = cp_cal_type
285: AND ci_sequence_number = cp_ci_sequence_number;
286:
287: l_v_census_dt_alias igs_ge_s_gen_cal_con.census_dt_alias%TYPE;
288: l_d_check_dt_alias igs_ca_da_inst_v.alias_val%TYPE;
289: BEGIN
290:
291: p_d_cns_dt_als_val := NULL;
292: IF p_v_load_cal_type IS NULL OR

Line 4567: FROM igs_ca_da_inst_v daiv

4563: AND (
4564: -- In Predictive, Select only when Effective Date (i.e., SYSDATE) is less than FCCI Start Date Alias Value.
4565: ( g_c_predictive_ind = 'Y' AND
4566: (TRUNC(cp_effective_dt) < (SELECT TRUNC(daiv.alias_val)
4567: FROM igs_ca_da_inst_v daiv
4568: WHERE daiv.DT_ALIAS = fcci.start_dt_alias AND
4569: daiv.sequence_number = fcci.start_dai_sequence_number AND
4570: daiv.CAL_TYPE =fcci.fee_cal_type AND
4571: daiv.ci_sequence_number = fcci.fee_ci_sequence_number)

Line 4578: FROM igs_ca_da_inst_v daiv

4574: OR
4575: -- In Actual, Select only when FCCI is active as on Effective Date. (i.e., Eff Date <= FCCI Start Date Alias)
4576: ( g_c_predictive_ind = 'N' AND
4577: (TRUNC(cp_effective_dt) >= (SELECT TRUNC(daiv.alias_val)
4578: FROM igs_ca_da_inst_v daiv
4579: WHERE daiv.DT_ALIAS = fcci.start_dt_alias AND
4580: daiv.sequence_number = fcci.start_dai_sequence_number AND
4581: daiv.CAL_TYPE =fcci.fee_cal_type AND
4582: daiv.ci_sequence_number = fcci.fee_ci_sequence_number)

Line 4587: FROM IGS_CA_DA_INST_V daiv

4583: )
4584: )
4585: )
4586: AND TRUNC(cp_effective_dt) <= ( SELECT TRUNC(daiv.alias_val)
4587: FROM IGS_CA_DA_INST_V daiv
4588: WHERE daiv.DT_ALIAS = fcci.end_dt_alias
4589: AND daiv.sequence_number = fcci.end_dai_sequence_number
4590: AND daiv.CAL_TYPE =fcci.fee_cal_type
4591: AND daiv.ci_sequence_number = fcci.fee_ci_sequence_number)

Line 4614: FROM igs_ca_da_inst_v

4610: l_c_temp VARCHAR2(1);
4611:
4612: CURSOR c_daiv( cp_dt_alias igs_fi_f_cat_ca_inst.start_dt_alias%TYPE) IS
4613: SELECT alias_val
4614: FROM igs_ca_da_inst_v
4615: WHERE dt_alias = cp_dt_alias
4616: AND cal_type = p_fee_cal_type
4617: AND ci_sequence_number = p_fee_ci_sequence_num;
4618:

Line 7769: v_fcci_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;

7765: v_fee_assessment NUMBER;
7766: v_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;
7767: v_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE;
7768: v_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE;
7769: v_fcci_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7770: v_fcflv_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7771: v_fcflv_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7772: v_fcci_found BOOLEAN;
7773: v_fcfl_found BOOLEAN;

Line 7770: v_fcflv_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;

7766: v_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;
7767: v_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE;
7768: v_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE;
7769: v_fcci_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7770: v_fcflv_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7771: v_fcflv_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7772: v_fcci_found BOOLEAN;
7773: v_fcfl_found BOOLEAN;
7774: v_message_name VARCHAR2(30);

Line 7771: v_fcflv_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;

7767: v_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE;
7768: v_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE;
7769: v_fcci_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7770: v_fcflv_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7771: v_fcflv_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7772: v_fcci_found BOOLEAN;
7773: v_fcfl_found BOOLEAN;
7774: v_message_name VARCHAR2(30);
7775: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;

Line 7804: FROM igs_ca_da_inst_v daiv

7800: (
7801: -- In Predictive, Select only when Effective Date (i.e., SYSDATE) is less than FCFL Start Date Alias Value.
7802: ( g_c_predictive_ind = 'Y' AND
7803: (TRUNC(cp_effective_dt) < (SELECT TRUNC(daiv.alias_val)
7804: FROM igs_ca_da_inst_v daiv
7805: WHERE daiv.DT_ALIAS = fcci.start_dt_alias AND
7806: daiv.sequence_number = fcci.start_dai_sequence_number AND
7807: daiv.CAL_TYPE =fcci.fee_cal_type AND
7808: daiv.ci_sequence_number = fcci.fee_ci_sequence_number AND

Line 7815: FROM igs_ca_da_inst_v daiv

7811: OR
7812: -- In Actual, Select only when FCFL is active as on Effective Date. (i.e., Eff Date <= FCFL Start Date Alias)
7813: ( g_c_predictive_ind = 'N' AND
7814: (TRUNC(cp_effective_dt) >= (SELECT TRUNC(daiv.alias_val)
7815: FROM igs_ca_da_inst_v daiv
7816: WHERE daiv.DT_ALIAS = fcci.start_dt_alias AND
7817: daiv.sequence_number = fcci.start_dai_sequence_number AND
7818: daiv.CAL_TYPE =fcci.fee_cal_type AND
7819: daiv.ci_sequence_number = fcci.fee_ci_sequence_number AND

Line 7825: FROM IGS_CA_DA_INST_V daiv

7821: )
7822: ) AND
7823: TRUNC(cp_effective_dt) <=
7824: (SELECT TRUNC(daiv.alias_val)
7825: FROM IGS_CA_DA_INST_V daiv
7826: WHERE daiv.DT_ALIAS = fcci.end_dt_alias AND
7827: daiv.sequence_number = fcci.end_dai_sequence_number AND
7828: daiv.CAL_TYPE =fcci.fee_cal_type AND
7829: daiv.ci_sequence_number = fcci.fee_ci_sequence_number AND

Line 7834: FROM IGS_CA_DA_INST_V daiv

7830: daiv.alias_val IS NOT NULL) AND
7831: (p_discontinued_dt IS NULL OR
7832: (TRUNC(p_discontinued_dt) >=
7833: (SELECT TRUNC(daiv.alias_val)
7834: FROM IGS_CA_DA_INST_V daiv
7835: WHERE daiv.DT_ALIAS = fcci.start_dt_alias AND
7836: daiv.sequence_number = fcci.start_dai_sequence_number AND
7837: daiv.CAL_TYPE =fcci.fee_cal_type AND
7838: daiv.ci_sequence_number = fcci.fee_ci_sequence_number AND

Line 7842: FROM IGS_CA_DA_INST_V daiv

7838: daiv.ci_sequence_number = fcci.fee_ci_sequence_number AND
7839: daiv.alias_val IS NOT NULL) AND
7840: TRUNC(p_discontinued_dt) <=
7841: (SELECT TRUNC(daiv.alias_val)
7842: FROM IGS_CA_DA_INST_V daiv
7843: WHERE daiv.DT_ALIAS = fcci.end_dt_alias AND
7844: daiv.sequence_number = fcci.end_dai_sequence_number AND
7845: daiv.CAL_TYPE =fcci.fee_cal_type AND
7846: daiv.ci_sequence_number = fcci.fee_ci_sequence_number AND

Line 7858: FROM IGS_CA_DA_INST_V daiv

7854: cp_dai_sequence_number IGS_CA_DA_INST.sequence_number%TYPE,
7855: cp_fee_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE,
7856: cp_fee_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE) IS
7857: SELECT daiv.alias_val
7858: FROM IGS_CA_DA_INST_V daiv
7859: WHERE daiv.DT_ALIAS = cp_dt_alias AND
7860: daiv.sequence_number = cp_dai_sequence_number AND
7861: daiv.CAL_TYPE =cp_fee_cal_type AND
7862: daiv.ci_sequence_number = cp_fee_ci_sequence_number;