2159: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
2160: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
2161: shift_num shift_no ;
2162:
2163: TYPE f_dt IS TABLE OF mr_shcl_dtl.calendar_date%TYPE;
2164: f_date f_dt ;
2165:
2166: TYPE t_dt IS TABLE OF mr_shcl_dtl.calendar_date%TYPE;
2167: t_date t_dt ;
2162:
2163: TYPE f_dt IS TABLE OF mr_shcl_dtl.calendar_date%TYPE;
2164: f_date f_dt ;
2165:
2166: TYPE t_dt IS TABLE OF mr_shcl_dtl.calendar_date%TYPE;
2167: t_date t_dt ;
2168:
2169: BEGIN
2170: sql_del := NULL;