APPS.PFT_PROFCAL_VALIDX_PUB dependencies on PFT_VAL_INDEX_RANGES

Line 320: FROM pft_val_index_ranges

316: ,p_msg_text => 'Value Index Formula ' || p_value_index_formula_id);
317:
318: SELECT COUNT(measure_type)
319: INTO l_measure_type
320: FROM pft_val_index_ranges
321: WHERE value_index_formula_id = p_value_index_formula_id
322: AND measure_type = 'REGION_COUNTING';
323:
324: IF l_measure_type = 0 THEN

Line 348: FROM pft_val_index_ranges

344:
345: BEGIN
346: SELECT COUNT(measure_type)
347: INTO l_measure_type
348: FROM pft_val_index_ranges
349: WHERE value_index_formula_id = p_value_index_formula_id
350: AND measure_type = 'PROFIT_PERCENTILE';
351:
352: IF l_measure_type = 0 THEN

Line 1556: ' FROM pft_val_index_ranges a, ';

1552: l_update_stmt := ' UPDATE fem_customer_profit fcp' ||
1553: ' SET fcp.' || p_output_column ||' = NVL('||
1554: p_output_column || ',0) + ' ||
1555: ' ( SELECT NVL(factor_weight,0) ' ||
1556: ' FROM pft_val_index_ranges a, ';
1557:
1558: l_select_stmt := ' ( SELECT region_pct_total_cust, ' ||
1559: ' cust.customer_id ' ||
1560: ' FROM fem_customers_b cust, ' ||

Line 1678: ' FROM pft_val_index_ranges a, ';

1674: l_update_stmt := ' UPDATE fem_customer_profit fcp' ||
1675: ' SET fcp.' || p_output_column ||' = NVL('||
1676: p_output_column || ',0) + ' ||
1677: ' ( SELECT NVL(factor_weight,0) ' ||
1678: ' FROM pft_val_index_ranges a, ';
1679:
1680: l_select_stmt := ' (SELECT profit_percentile,cust.customer_id' ||
1681: ' FROM fem_customers_b cust, ' ||
1682: ' fem_customer_profit fcp ';