APPS.BIC_CONSOLIDATE_CUST_DATA_PKG dependencies on BIC_MEASURE_ATTRIBS

Line 114: l_measure_code bic_measure_attribs.measure_code % type;

110: l_TOTAL_SR_RESL_TIME number;
111: l_TOTAL_SR_RESPONSE_TIME number;
112:
113:
114: l_measure_code bic_measure_attribs.measure_code % type;
115: l_measure_value bic_customer_summary_all.value % type;
116: begin
117: g_date := to_date('01-01-1999','dd-mm-yyyy') ;
118: open c_parties;

Line 375: from bic_measure_attribs

371: end if;
372: /***********************
373: select ' elsif l_measure_code = ''' || measure_code || ''' then
374: l_' || measure_code || ' = l_measure_value'
375: from bic_measure_attribs
376: *****************************/
377: end loop;
378: close c_measure_values;
379:

Line 683: l_measure_code bic_measure_attribs.measure_code % type;

679: l_ACTIVATION number;
680: l_RETENTION number;
681: l_LIFE_CYCLE number;
682:
683: l_measure_code bic_measure_attribs.measure_code % type;
684: l_measure_value bic_customer_summary_all.value % type;
685: x_err varchar2(2000);
686: begin
687: g_date := to_date('01-01-1999','dd-mm-yyyy') ;