APPS.ZPB_OLAP_VIEWS_PKG dependencies on ZPB_USERS

Line 1326: l_persAw ZPB_USERS.PERSONAL_AW%type;

1322: return varchar2 is
1323: l_msg_cnt number;
1324: l_ret_stat varchar2(30);
1325: l_buff varchar2(500);
1326: l_persAw ZPB_USERS.PERSONAL_AW%type;
1327: l_ba_id number;
1328: l_shadow number;
1329: l_last_upd date;
1330: l_reattach boolean;

Line 1404: from ZPB_USERS

1400:
1401: if (upper(p_type) = 'PERSONAL') then
1402: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW
1403: into l_persAw
1404: from ZPB_USERS
1405: where BUSINESS_AREA_ID = l_ba_id
1406: and USER_ID = l_shadow;
1407:
1408: --

Line 1451: l_persAw ZPB_USERS.PERSONAL_AW%type;

1447: is
1448: l_msg_cnt number;
1449: l_ret_stat varchar2(30);
1450: l_buff varchar2(500);
1451: l_persAw ZPB_USERS.PERSONAL_AW%type;
1452: l_ba_id number;
1453: l_shadow number;
1454: l_last_upd date;
1455: l_reattach boolean;

Line 1524: from ZPB_USERS

1520:
1521: if (upper(p_type) = 'PERSONAL') then
1522: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW
1523: into l_persAw
1524: from ZPB_USERS
1525: where BUSINESS_AREA_ID = l_ba_id
1526: and USER_ID = l_shadow;
1527:
1528: --

Line 1593: from ZPB_USERS

1589:
1590:
1591: cursor c_users is
1592: select user_id
1593: from ZPB_USERS
1594: where BUSINESS_AREA_ID = p_business_area;
1595: begin
1596: select DATA_AW
1597: into l_aw