eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_RU_ENGINE_PVT dependencies on FEM_ACTIVITIES_HIER

Line 4695: from fem_activities_hier h

4691: ,h.child_id
4692: ,h.single_depth_flag
4693: ,h.weighting_pct
4694: ,nvl(n.costed_flag,'N') as costed_flag
4695: from fem_activities_hier h
4696: ,fem_ru_nodes_t n
4697: where h.hierarchy_obj_def_id = p_rule_rec.hier_obj_def_id
4698: and h.child_id <> h.parent_id
4699: and h.single_depth_flag = 'Y'

Line 5019: from fem_activities_hier h

5015: else
5016:
5017: select min(h.parent_depth_num)
5018: into l_min_parent_depth_num
5019: from fem_activities_hier h
5020: where h.hierarchy_obj_def_id = p_rule_rec.hier_obj_def_id
5021: and h.child_id <> h.parent_id
5022: and h.single_depth_flag = 'Y'
5023: and h.parent_id = p_top_node_id;

Line 5027: from fem_activities_hier h

5023: and h.parent_id = p_top_node_id;
5024:
5025: select max(h.parent_depth_num)
5026: into l_max_parent_depth_num
5027: from fem_activities_hier h
5028: where h.hierarchy_obj_def_id = p_rule_rec.hier_obj_def_id
5029: and h.child_id <> h.parent_id
5030: and h.single_depth_flag = 'Y';
5031: