APPS.ZPB_BUSAREA_MAINT dependencies on DUAL

Line 287: from dual;

283: -- "Consistent Dimension"
284: -- Get the Logical Dimension Id from the sequence
285: Select zpb_busarea_logical_dims_seq.nextval
286: into l_logical_dim_id
287: from dual;
288:
289: -- "Consistent Dimension"
290: -- Generate the AW Logical Dimension Name and Dim Prefix
291:

Line 750: select ZPB_BUSINESS_AREAS_SEQ.nextval into l_business_area_id from dual;

746: l_user_id FND_USER.USER_ID%type;
747: begin
748: l_user_id := FND_GLOBAL.USER_ID;
749:
750: select ZPB_BUSINESS_AREAS_SEQ.nextval into l_business_area_id from dual;
751:
752: insert into ZPB_BUSINESS_AREAS
753: (BUSINESS_AREA_ID,
754: BUSAREA_CREATED_BY,

Line 876: select ZPB_BUSAREA_VERSIONS_SEQ.nextval into l_version_id from dual;

872: where BUSINESS_AREA_ID = p_business_area_id
873: and VERSION_TYPE = p_version_type;
874:
875: else
876: select ZPB_BUSAREA_VERSIONS_SEQ.nextval into l_version_id from dual;
877:
878: insert into ZPB_BUSAREA_VERSIONS
879: (VERSION_ID,
880: BUSINESS_AREA_ID,

Line 1350: select ZPB_AW.GET_SCHEMA||'.SQTEMP'||p_business_area_id from dual;

1346: select ZPB_AW.GET_SCHEMA||'.'||ANNOTATION_AW AW_NAME
1347: from ZPB_BUSINESS_AREAS
1348: where BUSINESS_AREA_ID = p_business_area_id
1349: UNION
1350: select ZPB_AW.GET_SCHEMA||'.SQTEMP'||p_business_area_id from dual;
1351:
1352: l_aws l_aws_curs%ROWTYPE;
1353:
1354: cursor l_session_curs(l_aw_name VARCHAR2) is