APPS.BIC_LIFECYCLE_EXTRACT_PKG dependencies on BIC_MEASURES_ALL

Line 197: 'Measure_id not found for LIFE_CYCLE in the table BIC_MEASURES_ALL');

193: WHEN NO_LC_MEASURE_ID THEN
194: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
195: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
196: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,
197: 'Measure_id not found for LIFE_CYCLE in the table BIC_MEASURES_ALL');
198: ROLLBACK;
199: WHEN OTHERS THEN
200: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
201: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

Line 312: bic_customer_summary_all c, bic_measures_all m, bic_temp_periods d

308:
309: x_sc1 := 'SELECT start_date, customer_id , ' ;
310: x_s2 := 'sum(c.value) p1_value, 0 p2_value ' ;
311: x_sc2 := 'FROM
312: bic_customer_summary_all c, bic_measures_all m, bic_temp_periods d
313: WHERE c.measure_id = m.measure_id
314: AND m.measure_code = ''' || g_measure_for_lc_stage || '''
315: AND d.start_date BETWEEN ''' || g_lc_st_month || '''
316: AND ''' || g_lc_end_month || '''

Line 640: FROM bic_measures_all

636:
637:
638:
639: SELECT measure_id INTO g_lc_measure_id
640: FROM bic_measures_all
641: WHERE measure_code = 'LIFE_CYCLE' AND org_id IS NULL ;
642:
643:
644: