DBA Data[Home] [Help]

APPS.GME_GANTT_PKG dependencies on BOM_CALENDARS

Line 1459: FROM mtl_parameters p, bom_calendars c

1455: IS
1456: CURSOR get_mfg_cal_code
1457: IS
1458: SELECT p.calendar_code, c.description
1459: FROM mtl_parameters p, bom_calendars c
1460: WHERE p.organization_id = p_organization_id
1461: AND c.calendar_code = p.calendar_code;
1462: BEGIN
1463: OPEN get_mfg_cal_code;

Line 1498: FROM bom_calendars

1494: CURSOR get_calendar_date_range (p_calendar_code VARCHAR2)
1495: IS
1496: SELECT MIN (date_to_clientdt (calendar_start_date) )
1497: ,MAX (date_to_clientdt (calendar_end_date) )
1498: FROM bom_calendars
1499: WHERE calendar_code = p_calendar_code;
1500:
1501: l_api_name CONSTANT VARCHAR2 (30) := 'Fetch_Shop_Calendar';
1502: inv_calendar_sel EXCEPTION;