DBA Data[Home] [Help]

APPS.BSC_UPDATE_BASE dependencies on BSC_SYS_PERIODICITIES

Line 431: FROM bsc_db_calculations c, bsc_sys_periodicities p

427: h_end_year NUMBER;
428:
429: CURSOR c_other_periodicities (p_table_name VARCHAR2, p_calc_type NUMBER) IS
430: SELECT c.parameter1, p.yearly_flag
431: FROM bsc_db_calculations c, bsc_sys_periodicities p
432: WHERE c.table_name = p_table_name AND c.calculation_type = p_calc_type AND
433: c.parameter1 = p.periodicity_id;
434:
435: h_other_periodicity_id NUMBER;

Line 1498: FROM BSC_DB_CALCULATIONS C, BSC_SYS_PERIODICITIES P

1494: ) RETURN BOOLEAN IS
1495:
1496: CURSOR c_Calc_Period IS
1497: SELECT TO_NUMBER(C.PARAMETER1) Parameter1, P.CALENDAR_ID Calendar_Id, P.DB_COLUMN_NAME Db_Column_Name
1498: FROM BSC_DB_CALCULATIONS C, BSC_SYS_PERIODICITIES P
1499: WHERE C.Parameter1 = P.Periodicity_Id
1500: AND C.Calculation_Type = 6
1501: AND C.Table_Name = p_table_name;
1502: