APPS.PER_PGT_BUS dependencies on PER_GEN_HIERARCHY_NODES

Line 521: FROM per_gen_hierarchy_nodes

517: WHERE flex_value_set_name = p_child_value_set;
518:
519: CURSOR csr_node_used is
520: SELECT 'Y'
521: FROM per_gen_hierarchy_nodes
522: WHERE node_type = to_char(p_hier_node_type_id);
523:
524: --
525: l_proc varchar2(72) := g_package||'chk_child_value_set';

Line 703: from per_gen_hierarchy_nodes

699:
700: -- csr to see if any hierarchy nodes reference this scope
701: CURSOR csr_node_used is
702: select 'Y'
703: from per_gen_hierarchy_nodes
704: where node_type = to_char(p_rec.hier_node_type_id);
705:
706: l_proc varchar2(72) := g_package||'delete_validate';
707: l_dummy varchar2(1);