DBA Data[Home] [Help]

APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_PL_OBJECT_EXECUTIONS

Line 2199: SELECT 1 FROM fem_pl_object_executions

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 );

Line 2436: FROM fem_pl_object_executions o

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