2195: TYPE refcursor IS REF CURSOR;
2196: exec_cur refcursor;
2197:
2198: Cursor BalRuleExec(c_charts_of_account_id NUMBER) IS
2199: SELECT 1 FROM fem_pl_object_executions
2200: WHERE object_id
2201: IN (SELECT BAL_RULE_OBJ_ID
2202: FROM fem_intg_bal_rules
2203: WHERE chart_of_accounts_id =c_charts_of_account_id );
2432: -- getting the max reuest ID
2433:
2434: SELECT max(o.request_id)
2435: INTO l_request_id
2436: FROM fem_pl_object_executions o
2437: WHERE o.display_flag = 'Y'
2438: AND o.object_id = p_dim_rule_obj_id;
2439:
2440: FEM_ENGINES_PKG.Tech_Message