APPS.BSC_DBGEN_METADATA_READER dependencies on BSC_KPI_PERIODICITIES

Line 340: select kpi.indicator from bsc_kpi_periodicities kpi,

336: is
337:
338:
339: cursor cCalendars IS
340: select kpi.indicator from bsc_kpi_periodicities kpi,
341: bsc_sys_periodicities sysper
342: where kpi.periodicity_id = sysper.periodicity_id
343: and sysper.calendar_id= p_calendar_id;
344: l_fact_ids dbms_sql.number_table;

Line 373: bsc_kpi_periodicities kpi

369: l_calendar_id NUMBER;
370: cursor cCal is
371: SELECT calendar_id
372: FROM bsc_sys_periodicities sysper,
373: bsc_kpi_periodicities kpi
374: where kpi.periodicity_id = sysper.periodicity_id
375: and kpi.indicator = to_number(p_fact);
376: Begin
377: OPEN cCal;