224: FROM fem_pl_object_executions
225: WHERE exec_object_definition_id = cv_obj_def_id
226: UNION
227: SELECT cv_request_id
228: FROM dual
229: ORDER BY request_id;
230: --
231: BEGIN
232: --
2307: -- GetPreviewAmount
2308: --
2309: -- DESCRIPTION
2310: -- Returns the summed amount and its associated currency for a given
2311: -- temporary table. If the individual amounts are represented in
2312: -- currencies other than the functional currency, this procedure will
2313: -- convert those amounts to the functional currency amount before
2314: -- summing them.
2315: --