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

Line 1282: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,

1278: ORDER BY ci.start_dt DESC;
1279: --
1280: -- Cursor to fetch the date alias
1281: --
1282: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
1283: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
1284: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
1285: SELECT daiv.alias_val
1286: FROM igs_ca_da_inst_v daiv

Line 1283: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,

1279: --
1280: -- Cursor to fetch the date alias
1281: --
1282: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
1283: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
1284: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
1285: SELECT daiv.alias_val
1286: FROM igs_ca_da_inst_v daiv
1287: WHERE daiv.cal_type = cp_cal_type

Line 1286: FROM igs_ca_da_inst_v daiv

1282: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
1283: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
1284: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
1285: SELECT daiv.alias_val
1286: FROM igs_ca_da_inst_v daiv
1287: WHERE daiv.cal_type = cp_cal_type
1288: AND daiv.ci_sequence_number = cp_ci_sequence_number
1289: AND daiv.dt_alias = cp_load_effect_dt_alias;
1290: --

Line 2736: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,

2732:
2733: --
2734: -- CURSOR TO FETCH THE DATE ALIAS
2735: --
2736: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
2737: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
2738: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
2739: SELECT daiv.alias_val
2740: FROM igs_ca_da_inst_v daiv

Line 2737: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,

2733: --
2734: -- CURSOR TO FETCH THE DATE ALIAS
2735: --
2736: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
2737: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
2738: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
2739: SELECT daiv.alias_val
2740: FROM igs_ca_da_inst_v daiv
2741: WHERE daiv.cal_type = cp_cal_type

Line 2740: FROM igs_ca_da_inst_v daiv

2736: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
2737: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
2738: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
2739: SELECT daiv.alias_val
2740: FROM igs_ca_da_inst_v daiv
2741: WHERE daiv.cal_type = cp_cal_type
2742: AND daiv.ci_sequence_number = cp_ci_sequence_number
2743: AND daiv.dt_alias = cp_load_effect_dt_alias;
2744:

Line 2916: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,

2912:
2913: --
2914: -- CURSOR TO FETCH THE DATE ALIAS
2915: --
2916: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
2917: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
2918: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
2919: SELECT daiv.alias_val
2920: FROM igs_ca_da_inst_v daiv

Line 2917: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,

2913: --
2914: -- CURSOR TO FETCH THE DATE ALIAS
2915: --
2916: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
2917: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
2918: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
2919: SELECT daiv.alias_val
2920: FROM igs_ca_da_inst_v daiv
2921: WHERE daiv.cal_type = cp_cal_type

Line 2920: FROM igs_ca_da_inst_v daiv

2916: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
2917: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
2918: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
2919: SELECT daiv.alias_val
2920: FROM igs_ca_da_inst_v daiv
2921: WHERE daiv.cal_type = cp_cal_type
2922: AND daiv.ci_sequence_number = cp_ci_sequence_number
2923: AND daiv.dt_alias = cp_load_effect_dt_alias;
2924:

Line 3150: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,

3146: ORDER BY ci.start_dt DESC;
3147: --
3148: -- Cursor to fetch the date alias
3149: --
3150: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
3151: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
3152: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
3153: SELECT daiv.alias_val
3154: FROM igs_ca_da_inst_v daiv

Line 3151: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,

3147: --
3148: -- Cursor to fetch the date alias
3149: --
3150: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
3151: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
3152: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
3153: SELECT daiv.alias_val
3154: FROM igs_ca_da_inst_v daiv
3155: WHERE daiv.cal_type = cp_cal_type

Line 3154: FROM igs_ca_da_inst_v daiv

3150: CURSOR c_dai_v (cp_cal_type igs_ca_da_inst_v.cal_type%TYPE,
3151: cp_ci_sequence_number igs_ca_da_inst_v.ci_sequence_number%TYPE,
3152: cp_load_effect_dt_alias igs_en_cal_conf.load_effect_dt_alias%TYPE) IS
3153: SELECT daiv.alias_val
3154: FROM igs_ca_da_inst_v daiv
3155: WHERE daiv.cal_type = cp_cal_type
3156: AND daiv.ci_sequence_number = cp_ci_sequence_number
3157: AND daiv.dt_alias = cp_load_effect_dt_alias;
3158: --