APPS.BSC_DBGEN_BSC_READER dependencies on BSC_KPI_PERIODICITIES

Line 1441: FROM BSC_KPI_PERIODICITIES kpi, bsc_sys_periodicities s

1437: FUNCTION Get_Periodicities_For_Fact(p_fact IN VARCHAR2) RETURN BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity IS
1438: colPeriodicities BSC_DBGEN_STD_METADATA.tab_ClsPeriodicity;
1439: CURSOR cPeriodicities IS
1440: SELECT kpi.PERIODICITY_ID, NVL(TARGET_LEVEL, 1) AS TARGET_LEVEL, s.calendar_id
1441: FROM BSC_KPI_PERIODICITIES kpi, bsc_sys_periodicities s
1442: WHERE
1443: kpi.periodicity_id = s.periodicity_id
1444: AND kpi.INDICATOR = to_number(p_fact)
1445: ORDER BY PERIODICITY_ID;

Line 2294: select current_period from bsc_kpi_periodicities

2290: p_fact varchar2,
2291: p_periodicity number) return number is
2292: ------------------------------
2293: cursor cCurrentPeriod IS
2294: select current_period from bsc_kpi_periodicities
2295: where indicator=to_number(p_fact)
2296: and periodicity_id=p_periodicity;
2297: l_current_period NUMBER;
2298: ------------------------------

Line 2304: select periodicity_id from bsc_kpi_periodicities

2300: select source, db_column_name, calendar_id from bsc_sys_periodicities
2301: where periodicity_id=pp_periodicity;
2302: ------------------------------
2303: cursor cKPIPeriodicity is
2304: select periodicity_id from bsc_kpi_periodicities
2305: where indicator = to_number(p_fact);
2306: ------------------------------
2307: l_kpi_periodicity number;
2308: l_stmt VARCHAR2(1000);