DBA Data[Home] [Help]

APPS.ZPB_AW dependencies on ZPB_CURRENT_USER_V

Line 201: from ZPB_CURRENT_USER_V;

197: sys_context('ZPB_CONTEXT', 'business_area_id'));
198: if (l_business_area_id is null) then
199: select BUSINESS_AREA_ID
200: into l_business_area_id
201: from ZPB_CURRENT_USER_V;
202: end if;
203:
204: select ANNOTATION_AW
205: into l_annotation_aw

Line 247: from ZPB_CURRENT_USER_V;

243: sys_context('ZPB_CONTEXT', 'business_area_id'));
244: if (l_business_area_id is null) then
245: select BUSINESS_AREA_ID
246: into l_business_area_id
247: from ZPB_CURRENT_USER_V;
248: end if;
249:
250: l_user := to_number(nvl(p_user, sys_context('ZPB_CONTEXT', 'shadow_id')));
251: if (l_user is null) then

Line 254: from ZPB_CURRENT_USER_V;

250: l_user := to_number(nvl(p_user, sys_context('ZPB_CONTEXT', 'shadow_id')));
251: if (l_user is null) then
252: select SHADOW_ID
253: into l_user
254: from ZPB_CURRENT_USER_V;
255: end if;
256:
257: begin
258: select PERSONAL_AW

Line 291: from ZPB_CURRENT_USER_V;

287: sys_context('ZPB_CONTEXT', 'business_area_id'));
288: if (l_business_area_id is null) then
289: select BUSINESS_AREA_ID
290: into l_business_area_id
291: from ZPB_CURRENT_USER_V;
292: end if;
293:
294: select DATA_AW
295: into l_shared_aw