eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MO_DB_PKG dependencies on BSC_SYS_PERIODICITIES

Line 846: -- It is got from BSC_SYS_PERIODICITIES table

842: -- GetSubperiodColumnName : GetNombreCampoSubPeriod
843: --
844: -- DESCRIPTION:
845: -- RETURNs the subperiod column name of the given periodicity.
846: -- It is got from BSC_SYS_PERIODICITIES table
847: --
848: -- PARAMETERS:
849: -- Periodicidad: Periodicity code
850: --****************************************************************************

Line 856: FROM BSC_SYS_PERIODICITIES

852:
853: l_RETURN VARCHAR2(100);
854: CURSOR c1 IS
855: SELECT SUBPERIOD_COL_NAME
856: FROM BSC_SYS_PERIODICITIES
857: WHERE PERIODICITY_ID = Periodicity;
858: l_error varchar2(1000);
859: BEGIN
860:

Line 894: FROM BSC_SYS_PERIODICITIES

890: FUNCTION GetPeriodColumnName(Periodicity IN NUMBER) RETURN VARCHAR2 IS
891:
892: CURSOR c1 IS
893: SELECT PERIOD_COL_NAME
894: FROM BSC_SYS_PERIODICITIES
895: WHERE PERIODICITY_ID = Periodicity;
896: l_RETURN VARCHAR2(100);
897: l_error VARCHAR2(1000);
898: BEGIN

Line 986: FROM bsc_sys_periodicities

982:
983: FUNCTION getDataTypeForTimeFK(pCalendar IN NUMBER, pPeriodicity IN NUMBER) return VARCHAR2 IS
984: CURSOR cPeriodicityType IS
985: SELECT periodicity_type
986: FROM bsc_sys_periodicities
987: where calendar_id = pCalendar
988: and periodicity_id = pPeriodicity;
989:
990: l_periodicity NUMBER;