DBA Data[Home] [Help]

APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_PL_OBJECT_EXECUTIONS

Line 221: -- in that case, cannot rely on fem_pl_object_executions - hence the UNION.

217: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
218: --
219: -- Gets all object executions for a given preview rule.
220: -- In some cases, only fem_pl_requests gets registered and so
221: -- in that case, cannot rely on fem_pl_object_executions - hence the UNION.
222: CURSOR c_prvw_execs(cv_obj_def_id NUMBER, cv_request_id NUMBER) IS
223: SELECT request_id
224: FROM fem_pl_object_executions
225: WHERE exec_object_definition_id = cv_obj_def_id

Line 224: FROM fem_pl_object_executions

220: -- In some cases, only fem_pl_requests gets registered and so
221: -- in that case, cannot rely on fem_pl_object_executions - hence the UNION.
222: CURSOR c_prvw_execs(cv_obj_def_id NUMBER, cv_request_id NUMBER) IS
223: SELECT request_id
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