APPS.BIC_LIFECYCLE_EXTRACT_PKG dependencies on BIC_TEMP_PERIODS

Line 110: FROM bic_temp_periods;

106: p_end_date);
107:
108: END IF;
109: SELECT count(*) INTO rec_count
110: FROM bic_temp_periods;
111: IF rec_count = 0 THEN
112: write_log('LIFE_CYCLE data already extracted',
113: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
114: RETURN;

Line 260: bic_temp_periods bdt

256: ,g_program_id
257: ,SYSDATE
258: ,NULL
259: FROM
260: bic_temp_periods bdt
261: WHERE
262: bdt.start_date BETWEEN g_lc_st_month AND g_lc_end_month
263: AND x_account_established_date BETWEEN
264: ADD_MONTHS(bdt.act_period_end_date,g_lc_new_cust_period *-1)+1

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 || '''