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.

[Home] [Help]

APPS.IGS_EN_GEN_015 dependencies on IGS_CA_DA_INST

Line 40: igs_ca_da_inst dai

36: dai.ci_sequence_number
37: )
38: ) AS term_census_date
39: FROM igs_ge_s_gen_cal_con sgcc,
40: igs_ca_da_inst dai
41: WHERE sgcc.s_control_num = 1
42: AND dai.dt_alias = sgcc.census_dt_alias
43: AND dai.cal_type = cp_cal_type
44: AND dai.ci_sequence_number = cp_cal_seq_number

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 2745: l_load_alias_value igs_ca_da_inst.absolute_val%TYPE;

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:
2745: l_load_alias_value igs_ca_da_inst.absolute_val%TYPE;
2746:
2747:
2748: BEGIN
2749:

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 2948: l_load_alias_value igs_ca_da_inst.absolute_val%TYPE;

2944: AND ci.start_dt <= SYSDATE
2945: AND ci.end_dt >= SYSDATE
2946: ORDER BY ci.start_dt;
2947:
2948: l_load_alias_value igs_ca_da_inst.absolute_val%TYPE;
2949:
2950: BEGIN
2951:
2952: --fetch load effective date alias from enrollment calendar configuration

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