DBA Data[Home] [Help]

APPS.FPA_UTILS_PVT dependencies on FPA_LOOKUPS_V

Line 764: select NVL(meaning,NULL) into l_unit from fpa_lookups_V

760: if p_metric_code = 'NPV' then
761: select NVL(currency_code,NULL) into l_unit from fpa_aw_pc_info_v
762: where planning_cycle = p_planning_cycle_id;
763: else
764: select NVL(meaning,NULL) into l_unit from fpa_lookups_V
765: where lookup_type ='FPA_UNITS'
766: AND lookup_code = decode(p_metric_code, 'IRR', 'PERCENT','PAYBACKPERIOD', 'MONTHS');
767: end if;
768: