DBA Data[Home] [Help]

APPS.IGS_EN_DASHBOARD dependencies on IGS_EN_CAL_CONF

Line 165: FROM igs_en_cal_conf

161: AND ROWNUM <2;
162:
163: CURSOR c_cal_conf IS
164: SELECT planning_open_dt_alias, schedule_open_dt_alias
165: FROM igs_en_cal_conf
166: WHERE s_control_num = 1;
167: l_plan_dalias igs_en_cal_conf.planning_open_dt_alias %TYPE;
168: l_sch_dalias igs_en_cal_conf.schedule_open_dt_alias%TYPE;
169:

Line 167: l_plan_dalias igs_en_cal_conf.planning_open_dt_alias %TYPE;

163: CURSOR c_cal_conf IS
164: SELECT planning_open_dt_alias, schedule_open_dt_alias
165: FROM igs_en_cal_conf
166: WHERE s_control_num = 1;
167: l_plan_dalias igs_en_cal_conf.planning_open_dt_alias %TYPE;
168: l_sch_dalias igs_en_cal_conf.schedule_open_dt_alias%TYPE;
169:
170: i NUMBER;
171: l_n_temp NUMBER;

Line 168: l_sch_dalias igs_en_cal_conf.schedule_open_dt_alias%TYPE;

164: SELECT planning_open_dt_alias, schedule_open_dt_alias
165: FROM igs_en_cal_conf
166: WHERE s_control_num = 1;
167: l_plan_dalias igs_en_cal_conf.planning_open_dt_alias %TYPE;
168: l_sch_dalias igs_en_cal_conf.schedule_open_dt_alias%TYPE;
169:
170: i NUMBER;
171: l_n_temp NUMBER;
172: l_d_alias_val DATE;