APPS.BSC_UPDATE_BASE dependencies on BSC_DB_TABLES

Line 48: FROM bsc_db_tables

44: -- Get the current period of the base table
45: BEGIN
46: SELECT NVL(current_period, 0)
47: INTO h_current_period
48: FROM bsc_db_tables
49: WHERE table_name = x_base_table;
50: EXCEPTION
51: WHEN NO_DATA_FOUND THEN
52: h_current_period := 0;

Line 227: FROM bsc_db_tables

223: -- Get the current period and subperiod of the input table
224: BEGIN
225: SELECT NVL(current_period, 0), NVL(current_subperiod, 0)
226: INTO h_current_period, h_current_subperiod
227: FROM bsc_db_tables
228: WHERE table_name = x_input_table;
229: EXCEPTION
230: WHEN NO_DATA_FOUND THEN
231: h_current_period := 0;

Line 628: FROM bsc_db_tables

624: -- With the optimization of the projection method we are going to delete projection (set NULL)
625: -- only the records for periods >current_period and <=new_current_period.
626:
627: SELECT project_flag INTO h_project_flag
628: FROM bsc_db_tables
629: WHERE table_name = x_base_table;
630:
631: IF h_project_flag = 1 THEN
632: -- Delete the projection from all the data columns in the table

Line 893: bsc_db_tables

889: END IF;
890:
891: IF NOT x_correction_flag THEN
892: UPDATE
893: bsc_db_tables
894: SET
895: current_period = h_per_input_table,
896: current_subperiod = h_subper_input_table
897: WHERE

Line 901: bsc_db_tables

897: WHERE
898: table_name = x_input_table;
899:
900: UPDATE
901: bsc_db_tables
902: SET
903: current_period = h_per_base_table
904: WHERE
905: table_name = x_base_table;