APPS.GMP_CALENDAR_PKG dependencies on BOM_SHIFT_DATES

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

1210: || ' sd.shift_num shift_no, '
1211: || ' st.from_time from_time, '
1212: || ' DECODE(st.to_time,0,86400,st.to_time) to_time '
1213: || ' FROM bom_calendars'||p_db_link||' cal, '
1214: || ' bom_shift_dates'||p_db_link||' sd, '
1215: || ' bom_shift_times'||p_db_link||' st '
1216: || ' WHERE cal.calendar_code = :curr_cal_code '
1217: || ' AND sd.calendar_code = cal.calendar_code '
1218: || ' AND st.calendar_code = sd.calendar_code '

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

1582: /* B3482001 - taking shift number from gmp_calendar_detail_gtmp */
1583: TYPE shift_no IS TABLE OF gmp_calendar_detail_gtmp.shift_num%TYPE;
1584: shift_num shift_no ;
1585:
1586: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1587: f_date f_dt ;
1588:
1589: TYPE t_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1590: t_date t_dt ;

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

1585:
1586: TYPE f_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1587: f_date f_dt ;
1588:
1589: TYPE t_dt IS TABLE OF bom_shift_dates.shift_date%TYPE;
1590: t_date t_dt ;
1591:
1592: Begin
1593: proc_name := 'net_rsrc_insert'; /* B13866449 Rajesh Patangya */

Line 2239: || ' (select min(LAST_UPDATE_DATE) lud from bom_shift_dates '

2235: sql_1 := ' SELECT count(*) from '
2236: || ' ( select min(LAST_UPDATE_DATE) lud from gmp_resource_avail '
2237: || ' where CALENDAR_CODE = :cal_code '
2238: || ' and ORGANIZATION_ID = :orgn_id ) gmp, '
2239: || ' (select min(LAST_UPDATE_DATE) lud from bom_shift_dates '
2240: || ' where CALENDAR_CODE = :cal_code ) bom '
2241: || ' WHERE bom.lud > gmp.lud ' ;
2242:
2243: OPEN sql_ref_1 FOR sql_1 USING p_calendar_code, p_org_id , p_calendar_code;