APPS.PER_US_VETS_100A_CONS_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 48: per_gen_hierarchy_versions pgv,

44: select
45: pgh.name, pgv.version_number, pgn.entity_id, pgn.hierarchy_node_id
46: from
47: per_gen_hierarchy pgh,
48: per_gen_hierarchy_versions pgv,
49: per_gen_hierarchy_nodes pgn
50: where
51: pgh.hierarchy_id = p_hierarchy_id
52: and pgh.hierarchy_id = pgv.hierarchy_id

Line 211: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;

207: lc_state varchar2(3);
208:
209: l_est_no number;
210: l_hierarchy_name per_gen_hierarchy.name%type;
211: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
212: l_parent_org_id varchar2(20);
213: l_parent_node_id varchar2(20);
214:
215: l_reporting_name hr_organization_information.org_information1%type;