APPS.PQH_GENERIC_PURGE dependencies on PER_GEN_HIER_NODE_TYPES

Line 411: per_gen_hier_node_types

407: get_child_alias(p_alias_name in pqh_table_route.table_alias%type) IS
408: SELECT
409: child_node_type
410: FROM
411: per_gen_hier_node_types
412: WHERE
413: parent_node_type = UPPER(p_alias_name) AND hierarchy_type = 'GENERIC_PURGE';
414: */
415: CURSOR csr_child_alias(p_alias_name IN pqh_table_route.table_alias%TYPE) IS

Line 417: FROM per_gen_hier_node_types

413: parent_node_type = UPPER(p_alias_name) AND hierarchy_type = 'GENERIC_PURGE';
414: */
415: CURSOR csr_child_alias(p_alias_name IN pqh_table_route.table_alias%TYPE) IS
416: SELECT child_node_type
417: FROM per_gen_hier_node_types
418: WHERE hierarchy_type = 'GENERIC_PURGE'
419: START WITH parent_node_type = UPPER(p_alias_name)
420: CONNECT BY parent_node_type = PRIOR child_node_type;
421: