APPS.PER_US_VETS_100A_SINGLE_PKG dependencies on PER_GEN_HIERARCHY

Line 47: per_gen_hierarchy pgh,

43: cursor c_hier_details is
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

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 49: per_gen_hierarchy_nodes pgn

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
53: and pgv.hierarchy_version_id = p_hierarchy_version_id

Line 61: per_gen_hierarchy_nodes pghn

57: cursor c_count_est is
58: select
59: count(pghn.hierarchy_node_id)
60: from
61: per_gen_hierarchy_nodes pghn
62: where
63: pghn.hierarchy_version_id = p_hierarchy_version_id
64: and pghn.node_type = 'EST';
65:

Line 133: ,per_gen_hierarchy_nodes pghn

129:
130: from
131: hr_location_extra_info hlei1
132: ,hr_location_extra_info hlei2
133: ,per_gen_hierarchy_nodes pghn
134: ,hr_locations_all eloc
135: where
136: pghn.parent_hierarchy_node_id = l_parent_node_id
137: and pghn.node_type = 'EST'

Line 171: l_hierarchy_name per_gen_hierarchy.name%type;

167: c_report_year2 varchar2(5);
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:

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;

Line 279: from per_gen_hierarchy_nodes pgn

275: AND hoi2.org_information_context = 'Reporting Categories'
276: AND hoi1.organization_id = hoi2.organization_id)
277: and asg.location_id in
278: (select distinct pgn.entity_id
279: from per_gen_hierarchy_nodes pgn
280: where pgn.hierarchy_version_id = p_hierarchy_version_id
281: AND (
282: pgn.hierarchy_node_id = l_est_node_id
283: OR pgn.parent_hierarchy_node_id = l_est_node_id)

Line 362: from per_gen_hierarchy_nodes

358: l_month_end_date date := P_DATE_END1;
359:
360: cursor c_entity is
361: select entity_id
362: from per_gen_hierarchy_nodes
363: where hierarchy_version_id = p_hierarchy_version_id
364: and (hierarchy_node_id = l_est_node_id
365: or parent_hierarchy_node_id = l_est_node_id);
366:

Line 1315: from per_gen_hierarchy_nodes pgn

1311: )
1312: and P_DATE_END1 between asg.effective_start_date and asg.effective_end_date
1313: and asg.location_id in
1314: (select distinct pgn.entity_id
1315: from per_gen_hierarchy_nodes pgn
1316: where pgn.hierarchy_version_id = p_hierarchy_version_id
1317: AND (
1318: pgn.hierarchy_node_id = l_est_node_id
1319: OR pgn.parent_hierarchy_node_id = l_est_node_id)