APPS.GMP_CALENDAR_PKG dependencies on BOM_SHIFT_DATES

Line 968: || ' bom_shift_dates'||p_db_link||' sd, '

964: || ' sd.shift_num shift_no, '
965: || ' st.from_time from_time, '
966: || ' st.to_time to_time '
967: || ' FROM bom_calendars'||p_db_link||' cal, '
968: || ' bom_shift_dates'||p_db_link||' sd, '
969: || ' bom_shift_times'||p_db_link||' st '
970: || ' WHERE cal.calendar_code = :curr_cal_code '
971: || ' AND sd.calendar_code = cal.calendar_code '
972: || ' AND st.calendar_code = sd.calendar_code '

Line 1323: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;

1319: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
1320: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
1321: shift_num shift_no ;
1322:
1323: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1324: f_date f_dt ;
1325:
1326: TYPE t_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1327: t_date t_dt ;

Line 1326: TYPE t_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;

1322:
1323: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1324: f_date f_dt ;
1325:
1326: TYPE t_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1327: t_date t_dt ;
1328:
1329: BEGIN
1330: