APPS.PER_US_VETS_100A_SINGLE_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 172: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;

168: c_report_year3 varchar2(5);
169: c_report_year4 varchar2(5);
170:
171: l_hierarchy_name per_gen_hierarchy.name%type;
172: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
173: l_parent_org_id varchar2(20);
174: l_parent_node_id varchar2(20);
175:
176: l_est_no number;