[Home] [Help]
1237: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS
1238: SELECT ci.cal_type,
1239: ci.sequence_number
1240: FROM igs_ca_inst ci,
1241: igs_ca_stat cs
1242: WHERE ci.cal_type = cp_cal_type
1243: AND ci.start_dt <= cp_effective_dt
1244: AND ci.end_dt >= cp_effective_dt
1245: AND cs.cal_status = ci.cal_status
1255: ci.start_dt,
1256: ci.end_dt
1257: FROM igs_ca_type ct,
1258: igs_ca_inst ci,
1259: igs_ca_stat cs,
1260: igs_ca_inst_rel cir
1261: WHERE ct.closed_ind = 'N'
1262: AND cs.s_cal_status = cst_active
1263: AND ci.cal_status = cs.cal_status
2718: ci.start_dt,
2719: ci.end_dt
2720: FROM igs_ca_type ct,
2721: igs_ca_inst ci,
2722: igs_ca_stat cs,
2723: igs_ca_inst_rel cir
2724: WHERE cs.s_cal_status = cst_active
2725: AND ci.cal_status = cs.cal_status
2726: AND ct.s_cal_cat = cst_load
2897: ci.start_dt,
2898: ci.end_dt
2899: FROM igs_ca_type ct,
2900: igs_ca_inst ci,
2901: igs_ca_stat cs,
2902: igs_ca_inst_rel cir
2903: WHERE cs.s_cal_status = cst_active
2904: AND ci.cal_status = cs.cal_status
2905: AND ct.s_cal_cat = cst_load
2931: ci.start_dt,
2932: ci.end_dt
2933: FROM igs_ca_type ct,
2934: igs_ca_inst ci,
2935: igs_ca_stat cs,
2936: igs_ca_inst_rel cir
2937: WHERE cs.s_cal_status = cst_active
2938: AND ci.cal_status = cs.cal_status
2939: AND ct.s_cal_cat = cst_load
3105: cp_effective_dt igs_ca_inst.start_dt%TYPE) IS
3106: SELECT ci.cal_type,
3107: ci.sequence_number
3108: FROM igs_ca_inst ci,
3109: igs_ca_stat cs
3110: WHERE ci.cal_type = cp_cal_type
3111: AND ci.start_dt <= cp_effective_dt
3112: AND ci.end_dt >= cp_effective_dt
3113: AND cs.cal_status = ci.cal_status
3123: ci.start_dt,
3124: ci.end_dt
3125: FROM igs_ca_type ct,
3126: igs_ca_inst ci,
3127: igs_ca_stat cs,
3128: igs_ca_inst_rel cir
3129: WHERE ct.closed_ind = 'N'
3130: AND cs.s_cal_status = cst_active
3131: AND ci.cal_status = cs.cal_status