APPS.WIP_PROD_INDICATORS dependencies on BOM_CALENDAR_DATES

Line 264: from bom_calendar_dates ;

260: begin
261:
262: select trunc(min(calendar_date))
263: into g_date_from
264: from bom_calendar_dates ;
265:
266: exception
267: when no_data_found then
268: g_date_from := sysdate ;

Line 281: from bom_calendar_dates ;

277: begin
278:
279: select trunc(max(calendar_date))
280: into g_date_to
281: from bom_calendar_dates ;
282:
283: exception
284: when no_data_found then
285: g_date_to := sysdate ;

Line 779: from bom_calendar_dates ;

775: begin
776:
777: select trunc(min(calendar_date))
778: into g_date_from
779: from bom_calendar_dates ;
780:
781: exception
782: when no_data_found then
783: g_date_from := sysdate ;

Line 796: from bom_calendar_dates ;

792: begin
793:
794: select trunc(max(calendar_date))
795: into g_date_to
796: from bom_calendar_dates ;
797:
798: exception
799: when no_data_found then
800: g_date_to := sysdate ;

Line 1013: from bom_calendar_dates ;

1009: begin
1010:
1011: select trunc(min(calendar_date))
1012: into g_date_from
1013: from bom_calendar_dates ;
1014:
1015: exception
1016: when no_data_found then
1017: g_date_from := sysdate ;

Line 1029: from bom_calendar_dates ;

1025: begin
1026:
1027: select trunc(max(calendar_date))
1028: into g_date_to
1029: from bom_calendar_dates ;
1030:
1031: exception
1032: when no_data_found then
1033: g_date_to := sysdate ;

Line 1512: from bom_calendar_dates ;

1508: begin
1509:
1510: select trunc(min(calendar_date))
1511: into g_date_from
1512: from bom_calendar_dates ;
1513:
1514: exception
1515: when no_data_found then
1516: g_date_from := sysdate ;

Line 1529: from bom_calendar_dates ;

1525: begin
1526:
1527: select trunc(max(calendar_date))
1528: into g_date_to
1529: from bom_calendar_dates ;
1530:
1531: exception
1532: when no_data_found then
1533: g_date_to := sysdate ;

Line 4202: from bom_calendar_dates ;

4198: begin
4199:
4200: select trunc(max(calendar_date))
4201: into g_date_to
4202: from bom_calendar_dates ;
4203:
4204: exception
4205: when no_data_found then
4206: g_date_to := sysdate ;

Line 4671: from bom_calendar_dates ;

4667: begin
4668:
4669: select trunc(max(calendar_date))
4670: into g_date_to
4671: from bom_calendar_dates ;
4672:
4673: exception
4674: when no_data_found then
4675: g_date_to := sysdate ;