APPS.ZPB_OLAP_VIEWS_PKG dependencies on ZPB_BUSINESS_AREAS

Line 1366: from ZPB_BUSINESS_AREAS

1362: --
1363: /*
1364: select LAST_AW_UPDATE
1365: into l_last_upd
1366: from ZPB_BUSINESS_AREAS
1367: where BUSINESS_AREA_ID = l_ba_id;
1368:
1369: if (l_last_upd is not null and
1370: upper(l_buff) <> 'NA' and

Line 1495: from ZPB_BUSINESS_AREAS

1491: --
1492: /*
1493: select LAST_AW_UPDATE
1494: into l_last_upd
1495: from ZPB_BUSINESS_AREAS
1496: where BUSINESS_AREA_ID = l_ba_id;
1497:
1498: if (l_last_upd is not null and
1499: upper(l_buff) <> 'NA' and

Line 1580: l_aw ZPB_BUSINESS_AREAS.DATA_AW%type;

1576: --
1577: -------------------------------------------------------------------------------
1578: procedure REMOVE_BUSAREA_VIEWS (p_business_area in NUMBER)
1579: is
1580: l_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
1581:
1582: -- b 5751055 bkport from 5658636
1583: cursor c_views is
1584: select view_name from user_views

Line 1598: from ZPB_BUSINESS_AREAS

1594: where BUSINESS_AREA_ID = p_business_area;
1595: begin
1596: select DATA_AW
1597: into l_aw
1598: from ZPB_BUSINESS_AREAS
1599: where BUSINESS_AREA_ID = p_business_area;
1600:
1601: for each in c_views loop
1602: drop_view(each.view_name);