APPS.BSC_DBGEN_BSC_READER dependencies on BSC_SYS_PERIODICITIES_VL

Line 834: FROM BSC_SYS_PERIODICITIES_VL

830: l_table_name VARCHAR2(100) := 'bsc_tmp_per_circ_'||userenv('SESSIONID');
831: l_stmt VARCHAR2(1000) := 'CREATE TABLE '||l_table_name||'(periodicity NUMBER, source NUMBER)';
832: CURSOR cPeriods (p_periodicity NUMBER) IS
833: SELECT SOURCE
834: FROM BSC_SYS_PERIODICITIES_VL
835: WHERE PERIODICITY_ID=p_periodicity;
836: l_parents VARCHAR2(4000);
837: l_temp NUMBER;
838: l_periodicity_list BSC_DBGEN_STD_METADATA.tab_clsPeriodicity;