DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_BUSINESS_AREAS_VL

Line 20: from ZPB_BUSINESS_AREAS_VL

16: l_name := FND_MESSAGE.GET;
17:
18: select count(*)
19: into l_count
20: from ZPB_BUSINESS_AREAS_VL
21: where NAME = l_name;
22:
23: if (l_count > 0) then
24: l_name := l_name||' '||l_count;

Line 1274: from ZPB_BUSINESS_AREAS_VL

1270:
1271: begin
1272: select NAME
1273: into l_ba_name
1274: from ZPB_BUSINESS_AREAS_VL
1275: where BUSINESS_AREA_ID = p_business_area_id;
1276: exception
1277: when no_data_found then
1278: l_ba_name := '';

Line 1595: from ZPB_BUSINESS_AREAS_VL

1591: l_desc FND_CONCURRENT_REQUESTS.DESCRIPTION%type;
1592: begin
1593: select NAME
1594: into l_ba_name
1595: from ZPB_BUSINESS_AREAS_VL
1596: where BUSINESS_AREA_ID = p_business_area_id;
1597:
1598: FND_MESSAGE.CLEAR;
1599: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUSAREA_REFRESH');