APPS.BSC_DBGEN_BSC_READER dependencies on DUAL

Line 533: SELECT BSC_INTERNAL_COLUMN_S.NEXTVAL INTO l_seq FROM DUAL;

529: l_seq NUMBER;
530:
531:
532: BEGIN
533: SELECT BSC_INTERNAL_COLUMN_S.NEXTVAL INTO l_seq FROM DUAL;
534: return 'BSCIC'||l_seq;
535: End;
536:
537: -- PRIVATE API

Line 2589: SELECT fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL') into l_mv_level from dual;

2585: close cimplType;
2586: if (l_impl_type = 2) then
2587: l_impl_type := 'AW';--Analytical Workspaces
2588: else
2589: SELECT fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL') into l_mv_level from dual;
2590: if (l_mv_level) is null then
2591: l_impl_type:='ST'; -- summary tables
2592: else
2593: l_impl_type := 'MV';-- Materialized view