APPS.PFT_PROFITAGG_PUB dependencies on FEM_RULESET_PROCESS_DATA

Line 230: from fem_ruleset_process_data rs,

226: CURSOR l_rule_set_rules(p_request_id IN NUMBER,p_ruleset_obj_id IN NUMBER) IS
227: select rs.child_obj_id
228: ,rs.child_obj_def_id
229: ,x.exec_status_code
230: from fem_ruleset_process_data rs,
231: fem_pl_object_executions x
232: where rs.request_id = p_request_id
233: and rs.rule_set_obj_id = p_ruleset_obj_id
234: and x.request_id(+) = rs.request_id

Line 2445: FROM fem_ruleset_process_data p,

2441: ,p_module => G_BLOCK||'.'||l_api_name
2442: ,p_msg_text => 'BEGIN');
2443: SELECT COUNT(*)
2444: INTO l_count
2445: FROM fem_ruleset_process_data p,
2446: fem_pl_object_executions x
2447: WHERE p.request_id = p_request_id AND
2448: p.request_id = x.request_id(+) AND
2449: p.rule_set_obj_id = p_rule_set_obj_id