APPS.BSC_UPDATE_BASE_V2 dependencies on BSC_SYS_PERIODICITIES

Line 2519: FROM bsc_db_calculations c, bsc_sys_periodicities p

2515: h_cursor t_cursor;
2516:
2517: CURSOR c_upper_periodicities (p_table_name VARCHAR2, p_calc_type NUMBER) IS
2518: SELECT c.parameter1, p.yearly_flag, p.db_column_name
2519: FROM bsc_db_calculations c, bsc_sys_periodicities p
2520: WHERE c.table_name = p_table_name AND c.calculation_type = p_calc_type AND
2521: c.parameter1 = p.periodicity_id;
2522:
2523: h_column_name VARCHAR2(30);

Line 2627: FROM bsc_db_calculations c, bsc_sys_periodicities p

2623: h_cursor t_cursor;
2624:
2625: CURSOR c_upper_periodicities (p_table_name VARCHAR2, p_calc_type NUMBER) IS
2626: SELECT c.parameter1, p.yearly_flag, p.db_column_name
2627: FROM bsc_db_calculations c, bsc_sys_periodicities p
2628: WHERE c.table_name = p_table_name AND c.calculation_type = p_calc_type AND
2629: c.parameter1 = p.periodicity_id;
2630:
2631: h_column_name VARCHAR2(30);

Line 3938: from bsc_db_calculations c, bsc_sys_periodicities p

3934: -- See if yearly is one of the higher periodicities
3935: BEGIN
3936: select c.parameter1
3937: into h_yearly_periodicity
3938: from bsc_db_calculations c, bsc_sys_periodicities p
3939: where c.table_name = x_base_table and
3940: c.calculation_type = 6 and
3941: c.parameter1 = p.periodicity_id and
3942: p.yearly_flag = 1;