APPS.PFT_ACCTRELCONS_PUB dependencies on FEM_RULESET_PROCESS_DATA

Line 241: FROM fem_ruleset_process_data p,

237: /* SELECT p.child_obj_def_id,
238: p.engine_execution_sequence,
239: p.child_obj_id,
240: x.exec_status_code
241: FROM fem_ruleset_process_data p,
242: fem_pl_object_executions x
243: WHERE p.request_id = p_request_id AND
244: p.request_id = x.request_id(+) AND
245: p.rule_set_obj_id = p_rule_set_obj_id*/

Line 249: from fem_ruleset_process_data rs,

245: p.rule_set_obj_id = p_rule_set_obj_id*/
246: select rs.child_obj_id
247: ,rs.child_obj_def_id
248: ,x.exec_status_code
249: from fem_ruleset_process_data rs,
250: fem_pl_object_executions x
251: where rs.request_id = p_request_id
252: and rs.rule_set_obj_id = p_ruleset_obj_id
253: and x.request_id(+) = rs.request_id

Line 2247: FROM fem_ruleset_process_data p,

2243: ,p_module => G_BLOCK||'.'||l_api_name
2244: ,p_msg_text => 'BEGIN');
2245: SELECT COUNT(*)
2246: INTO l_count
2247: FROM fem_ruleset_process_data p,
2248: fem_pl_object_executions x
2249: WHERE p.request_id = p_request_id AND
2250: p.request_id = x.request_id(+) AND
2251: p.rule_set_obj_id = p_rule_set_obj_id