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_GEN_001 dependencies on IGS_CA_DA

Line 76: igs_ca_da_inst_v da1,

72: CURSOR c_fcfldate IS
73: SELECT TRUNC(da1.alias_val) start_dt_alias_val,
74: TRUNC(da2.alias_val) end_dt_alias_val
75: FROM igs_fi_f_cat_fee_lbl_v fcflv,
76: igs_ca_da_inst_v da1,
77: igs_ca_da_inst_v da2
78: WHERE da1.dt_alias = fcflv.start_dt_alias
79: AND da1.sequence_number = fcflv.start_dai_sequence_number
80: AND da1.cal_type = fcflv.fee_cal_type

Line 77: igs_ca_da_inst_v da2

73: SELECT TRUNC(da1.alias_val) start_dt_alias_val,
74: TRUNC(da2.alias_val) end_dt_alias_val
75: FROM igs_fi_f_cat_fee_lbl_v fcflv,
76: igs_ca_da_inst_v da1,
77: igs_ca_da_inst_v da2
78: WHERE da1.dt_alias = fcflv.start_dt_alias
79: AND da1.sequence_number = fcflv.start_dai_sequence_number
80: AND da1.cal_type = fcflv.fee_cal_type
81: AND da1.ci_sequence_number = fcflv.fee_ci_sequence_number

Line 405: v_ftci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;

401: FROM IGS_FI_F_CAT_CA_INST fcci
402: WHERE fcci.FEE_CAT = cp_fee_cat AND
403: fcci.fee_cal_type = cp_fee_cal_type AND
404: fcci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
405: v_ftci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
406: v_ftci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
407: v_ftci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
408: v_fcci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
409: v_fcci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;

Line 406: v_ftci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;

402: WHERE fcci.FEE_CAT = cp_fee_cat AND
403: fcci.fee_cal_type = cp_fee_cal_type AND
404: fcci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
405: v_ftci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
406: v_ftci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
407: v_ftci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
408: v_fcci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
409: v_fcci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
410: v_fcci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

Line 407: v_ftci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

403: fcci.fee_cal_type = cp_fee_cal_type AND
404: fcci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
405: v_ftci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
406: v_ftci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
407: v_ftci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
408: v_fcci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
409: v_fcci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
410: v_fcci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
411: BEGIN

Line 408: v_fcci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;

404: fcci.fee_ci_sequence_number = cp_fee_ci_sequence_number;
405: v_ftci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
406: v_ftci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
407: v_ftci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
408: v_fcci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
409: v_fcci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
410: v_fcci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
411: BEGIN
412: -- get the required dt alias from the fee type calendar instance

Line 409: v_fcci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;

405: v_ftci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
406: v_ftci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
407: v_ftci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
408: v_fcci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
409: v_fcci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
410: v_fcci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
411: BEGIN
412: -- get the required dt alias from the fee type calendar instance
413: OPEN c_ftci_dai (p_dt_alias_column_name,

Line 410: v_fcci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;

406: v_ftci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
407: v_ftci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
408: v_fcci_alias_value IGS_CA_DA_INST_V.alias_val%TYPE;
409: v_fcci_dt_alias IGS_CA_DA.DT_ALIAS%TYPE;
410: v_fcci_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
411: BEGIN
412: -- get the required dt alias from the fee type calendar instance
413: OPEN c_ftci_dai (p_dt_alias_column_name,
414: p_dai_seq_num_column_name,

Line 998: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE) IS

994: cp_fee_ci_sequence_num IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
995: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
996: cp_fee_type IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,
998: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE) IS
999: SELECT daiv.alias_val
1000: FROM IGS_FI_FEE_RET_SCHD frtns,
1001: IGS_CA_DA_INST_V daiv
1002: WHERE frtns.fee_cal_type = cp_fee_cal_type AND

Line 1001: IGS_CA_DA_INST_V daiv

997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,
998: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE) IS
999: SELECT daiv.alias_val
1000: FROM IGS_FI_FEE_RET_SCHD frtns,
1001: IGS_CA_DA_INST_V daiv
1002: WHERE frtns.fee_cal_type = cp_fee_cal_type AND
1003: frtns.fee_ci_sequence_number = cp_fee_ci_sequence_num AND
1004: frtns.s_relation_type = cp_s_relation_type AND
1005: NVL(frtns.FEE_TYPE,'NULL') = NVL(cp_fee_type,'NULL') AND

Line 1013: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

1009: daiv.CAL_TYPE = frtns.fee_cal_type AND
1010: daiv.ci_sequence_number =frtns.fee_ci_sequence_number AND
1011: daiv.alias_val > cp_alias_val
1012: ORDER BY daiv.alias_val ASC;
1013: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1014: -------------------------------------------------------------------------------
1015: FUNCTION finl_get_ass_end_dt(
1016: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
1017: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,

Line 1029: FROM IGS_CA_DA_INST_V daiv,

1025: CURSOR c_ftci ( cp_fee_type IGS_FI_F_TYP_CA_INST.FEE_TYPE%TYPE,
1026: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
1027: cp_fee_ci_sequence_num IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE) IS
1028: SELECT daiv.alias_val
1029: FROM IGS_CA_DA_INST_V daiv,
1030: IGS_FI_F_TYP_CA_INST ftci
1031: WHERE ftci.FEE_TYPE = cp_fee_type AND
1032: ftci.fee_cal_type = cp_fee_cal_type AND
1033: ftci.fee_ci_sequence_number = cp_fee_ci_sequence_num AND

Line 1043: FROM IGS_CA_DA_INST_V daiv,

1039: CURSOR c_fcci ( cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
1040: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,
1041: cp_fee_ci_sequence_num IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE) IS
1042: SELECT daiv.alias_val
1043: FROM IGS_CA_DA_INST_V daiv,
1044: IGS_FI_F_CAT_CA_INST fcci
1045: WHERE fcci.FEE_CAT = cp_fee_cat AND
1046: fcci.fee_cal_type = cp_fee_cal_type AND
1047: fcci.fee_ci_sequence_number = cp_fee_ci_sequence_num AND

Line 1052: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

1048: daiv.DT_ALIAS = fcci.end_dt_alias AND
1049: daiv.sequence_number = fcci.end_dai_sequence_number AND
1050: daiv.CAL_TYPE = fcci.fee_cal_type AND
1051: daiv.ci_sequence_number = fcci.fee_ci_sequence_number;
1052: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1053: BEGIN
1054: -- check the retention schedule relationship
1055: IF p_s_relation_type = 'FTCI' THEN
1056: -- retention schedule is for a fee type cal instance