APPS.BSC_METADATA_DESC dependencies on BSC_KPI_PERIODICITIES

Line 386: FROM BSC_KPI_PERIODICITIES A

382: */
383: -------------------------------------
384: CURSOR c_KPI_Periodicities IS
385: SELECT PERIODICITY_ID, DISPLAY_ORDER, CURRENT_PERIOD, TARGET_LEVEL
386: FROM BSC_KPI_PERIODICITIES A
387: WHERE INDICATOR = l_Kpi_Id;
388:
389: CURSOR c_SYS_Periodicity IS
390: SELECT A.NAME, A.PERIODICITY_TYPE, A.PERIOD_TYPE_ID, A.RECORD_TYPE_ID

Line 671: l_not_found_msg := ' There is not any Periodicity defined in table BSC_KPI_PERIODICITIES ';

667: put_line(l_not_Analysis_Options0_msg);
668: END IF;
669:
670: -------------- kpi Periodicites Information.
671: l_not_found_msg := ' There is not any Periodicity defined in table BSC_KPI_PERIODICITIES ';
672: put_line('---------------------------------------------------------------------------');
673: put_line('Objective ID <'||l_Kpi_Id||'> Periodicities: ');
674: put_line('---------------------------------------------------------------------------');
675: FOR bsc_cd IN c_KPI_Periodicities LOOP

Line 680: l_not_found_msg2 := '--> ERROR. Objective ID <' ||l_Kpi_Id || '> assigned to invalide periodicity in table BSC_KPI_PERIODICITIES. Periodicity Id <' ||l_periodicity_id || '> not exitst in table BSC_SYS_PERIODICITIES_VL' ;

676: l_not_found_msg := NULL;
677: put_line('-> PERIODICITY_ID is <'||bsc_cd.PERIODICITY_ID ||'> ' );
678: -------------- Sys Periodicites Information.
679: l_periodicity_id := bsc_cd.PERIODICITY_ID;
680: l_not_found_msg2 := '--> ERROR. Objective ID <' ||l_Kpi_Id || '> assigned to invalide periodicity in table BSC_KPI_PERIODICITIES. Periodicity Id <' ||l_periodicity_id || '> not exitst in table BSC_SYS_PERIODICITIES_VL' ;
681: FOR bsc_Per_cd IN c_SYS_Periodicity LOOP
682: l_not_found_msg2 := NULL;
683: put_line('.... PERIODICITY_NAME is <'||bsc_Per_cd.NAME ||'> ' );
684: put_line('.... PERIODICITY_TYPE is <'||bsc_Per_cd.PERIODICITY_TYPE ||'> ' );