APPS.PER_ENV_BUS dependencies on PER_GEN_HIERARCHY_NODES

Line 281: -- Validates hierarchy_node_id, if set, exists in per_gen_hierarchy_nodes.

277: --
278: -- {Start Of Comments}
279: --
280: -- Description:
281: -- Validates hierarchy_node_id, if set, exists in per_gen_hierarchy_nodes.
282: -- Also checks that the parent calendar entry is using the same generic hierarchy
283: -- to which the node belongs, and that the node id is unique in per_cal_entry_values
284: -- for the parent calendar_entry_id. Insert only.
285: --

Line 311: FROM per_gen_hierarchy_nodes pgn

307: -- Check the node exists in the hierarchy version 1
308: -- as calendar hierarchies only have one version
309: CURSOR CSR_GEN_HIER (l_gen_hier NUMBER) IS
310: SELECT 'X'
311: FROM per_gen_hierarchy_nodes pgn
312: WHERE pgn.hierarchy_node_id = p_hierarchy_node_id
313: AND pgn.hierarchy_version_id = (select pgv.hierarchy_version_id
314: from per_gen_hierarchy_versions pgv
315: where pgv.hierarchy_id = l_gen_hier