APPS.AMS_ACTMETRICFACT_PVT dependencies on AMS_TERR_V

Line 281: FROM ams_terr_v

277:
278: -- get a node's node_value, parent node id
279: CURSOR c_fundfact_getnodeinfo(p_hierarchy_id NUMBER, p_node_id NUMBER) IS
280: SELECT node_value
281: FROM ams_terr_v
282: WHERE hierarchy_id = p_hierarchy_id
283: AND node_id = p_node_id;
284:
285: -- get allocation amount summary of this node's children

Line 300: (SELECT 1 FROM ams_terr_v terr

296: AND formula.level_depth= p_level_depth + 1
297: AND formula.parent_formula_id = p_formula_id
298: )
299: AND EXISTS
300: (SELECT 1 FROM ams_terr_v terr
301: WHERE terr.hierarchy_id = p_hierarchy_id
302: AND terr.parent_id = p_node_id
303: AND terr.node_id = fact.node_id);
304: