APPS.FEM_RU_ENGINE_PVT dependencies on FEM_COST_OBJECTS

Line 3000: ' ,fem_cost_objects parent'||

2996: p_sql_rec.comp_dim_comp_cols_using||
2997: p_sql_rec.comp_dim_data_cols_using||
2998: ' ,sum(b.xtd_balance_f) xtd_balance_f'||
2999: ' from fem_balances b'||
3000: ' ,fem_cost_objects parent'||
3001: ' where b.cost_object_id = :b_child_id'||
3002: ' and parent.cost_object_id = :b_parent_id'||
3003: ' and b.currency_type_code = ''ENTERED'''||
3004: ' and '||p_input_ds_b_where_clause||

Line 4620: from fem_cost_objects_hier h

4616: ,h.parent_id
4617: ,h.child_id
4618: ,h.child_sequence_num
4619: ,nvl(n.costed_flag,'N') as costed_flag
4620: from fem_cost_objects_hier h
4621: ,fem_cost_objects parent
4622: ,fem_ru_nodes_t n
4623: where h.hierarchy_obj_id = p_rule_rec.hier_obj_id
4624: and p_request_rec.effective_date between h.effective_start_date and h.effective_end_date

Line 4621: ,fem_cost_objects parent

4617: ,h.child_id
4618: ,h.child_sequence_num
4619: ,nvl(n.costed_flag,'N') as costed_flag
4620: from fem_cost_objects_hier h
4621: ,fem_cost_objects parent
4622: ,fem_ru_nodes_t n
4623: where h.hierarchy_obj_id = p_rule_rec.hier_obj_id
4624: and p_request_rec.effective_date between h.effective_start_date and h.effective_end_date
4625: and parent.cost_object_id = h.parent_id

Line 4635: ,fem_cost_objects child

4631: start with parent_id = p_top_node_id
4632: connect by prior child_id = parent_id
4633: and prior costed_flag = 'N'
4634: ) ru
4635: ,fem_cost_objects child
4636: where child.cost_object_id = ru.child_id;
4637:
4638: exception
4639: when g_connect_by_loop_error then

Line 4862: -- FEM_RU_NODES_T. A join to FEM_COST_OBJECTS is necessary for

4858:
4859: if (l_dimension_rec.dimension_varchar_label = 'COST_OBJECT') then
4860:
4861: -- The source table query comes from the list of uncosted nodes in
4862: -- FEM_RU_NODES_T. A join to FEM_COST_OBJECTS is necessary for
4863: -- Populate_Cost_Object_Id to work properly as it needs all the
4864: -- component dimension columns for the join on FEM_BALANCES.
4865: l_source_table_query_stmt :=
4866: ' select co.cost_object_id'||

Line 4867: ' from fem_cost_objects co'||

4863: -- Populate_Cost_Object_Id to work properly as it needs all the
4864: -- component dimension columns for the join on FEM_BALANCES.
4865: l_source_table_query_stmt :=
4866: ' select co.cost_object_id'||
4867: ' from fem_cost_objects co'||
4868: ' ,fem_ru_nodes_t n'||
4869: ' where n.created_by_request_id = :b_request_id'||
4870: ' and n.created_by_object_id = :b_rollup_obj_id'||
4871: ' and n.costed_flag = ''N'''||