APPS.ZPB_AW_STATUS dependencies on ZPB_STATUS_SQL

Line 86: FROM zpb_status_sql

82: queryCurs QueryCursType;
83:
84: CURSOR queries IS
85: SELECT status_sql_id, status_sql, dimension_name, hierarchy_name
86: FROM zpb_status_sql
87: WHERE (query_path = p_query)
88: ORDER BY DIMENSION_NAME, ROW_NUM;
89: BEGIN
90: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and

Line 284: FROM zpb_status_sql

280: queryCurs QueryCursType;
281:
282: CURSOR queries IS
283: SELECT status_sql_id, status_sql, dimension_name, hierarchy_name
284: FROM zpb_status_sql
285: WHERE (query_path = p_query)
286: ORDER BY DIMENSION_NAME, ROW_NUM;
287: BEGIN
288: l_aw := zpb_aw.get_personal_aw(p_user_id);

Line 367: from ZPB_STATUS_SQL

363: l_global_ecm zpb_ecm.global_ecm;
364:
365: cursor dimensions is
366: select distinct DIMENSION_NAME
367: from ZPB_STATUS_SQL
368: where (query_path = p_query);
369: begin
370:
371: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and

Line 415: FROM zpb_status_sql

411: queryCurs QueryCursType;
412:
413: CURSOR queries IS
414: SELECT status_sql
415: FROM zpb_status_sql
416: WHERE (query_path = p_query)
417: AND DIMENSION_NAME = p_dimension
418: ORDER BY ROW_NUM;
419: BEGIN