eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_US_VETS_100A_LIST_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 92: ,per_gen_hierarchy_nodes pghn

88: ltrim(rtrim(eloc.postal_code))) "Estab Address"
89: from
90: hr_location_extra_info hlei1
91: ,hr_location_extra_info hlei2
92: ,per_gen_hierarchy_nodes pghn
93: ,hr_locations_all eloc
94: where
95: (hlei1.information_type = 'VETS-100 Specific Information'
96: and hlei1.lei_information_category= 'VETS-100 Specific Information')

Line 107: l_hierarchy_name per_gen_hierarchy.name%type;

103: and eloc.location_id = pghn.entity_id;
104:
105: l_business_group_name varchar2(240); --Increased variable size for Bug#9038285
106: c_date_end date;
107: l_hierarchy_name per_gen_hierarchy.name%type;
108: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
109: l_parent_org_id varchar2(20);
110: l_parent_node_id per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
111: l_parent_node_id1 per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;

Line 108: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;

104:
105: l_business_group_name varchar2(240); --Increased variable size for Bug#9038285
106: c_date_end date;
107: l_hierarchy_name per_gen_hierarchy.name%type;
108: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
109: l_parent_org_id varchar2(20);
110: l_parent_node_id per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
111: l_parent_node_id1 per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
112: l_est_no number;

Line 110: l_parent_node_id per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;

106: c_date_end date;
107: l_hierarchy_name per_gen_hierarchy.name%type;
108: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
109: l_parent_org_id varchar2(20);
110: l_parent_node_id per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
111: l_parent_node_id1 per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
112: l_est_no number;
113:
114: l_reporting_name hr_organization_information.org_information1%type;

Line 111: l_parent_node_id1 per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;

107: l_hierarchy_name per_gen_hierarchy.name%type;
108: l_hierarchy_version_num per_gen_hierarchy_versions.VERSION_NUMBER%type;
109: l_parent_org_id varchar2(20);
110: l_parent_node_id per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
111: l_parent_node_id1 per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
112: l_est_no number;
113:
114: l_reporting_name hr_organization_information.org_information1%type;
115: l_Est_Node_Id per_gen_hierarchy_nodes.hierarchy_node_id%type;

Line 115: l_Est_Node_Id per_gen_hierarchy_nodes.hierarchy_node_id%type;

111: l_parent_node_id1 per_gen_hierarchy_nodes.parent_hierarchy_node_id%type;
112: l_est_no number;
113:
114: l_reporting_name hr_organization_information.org_information1%type;
115: l_Est_Node_Id per_gen_hierarchy_nodes.hierarchy_node_id%type;
116: l_Est_Rep_Name hr_location_extra_info.lei_information1%type;
117: l_Headquarters hr_location_extra_info.lei_information10%type;
118: l_est_add clob;
119: l_report_date varchar2(11);

Line 180: from per_gen_hierarchy_nodes pgn

176: and l_end_date between asg.effective_start_date and asg.effective_end_date
177: and l_end_date between peo.effective_start_date and peo.effective_end_date
178: and asg.location_id in
179: (select distinct pgn.entity_id
180: from per_gen_hierarchy_nodes pgn
181: where pgn.hierarchy_version_id = p_hierarchy_version_id
182: AND (
183: pgn.hierarchy_node_id = l_est_node_id
184: OR pgn.parent_hierarchy_node_id = l_est_node_id)

Line 232: from per_gen_hierarchy_nodes pgn

228: and l_end_date between asg.effective_start_date and asg.effective_end_date
229: and l_end_date between peo.effective_start_date and peo.effective_end_date
230: and asg.location_id in
231: (select distinct pgn.entity_id
232: from per_gen_hierarchy_nodes pgn
233: where pgn.hierarchy_version_id = p_hierarchy_version_id
234: AND (
235: pgn.hierarchy_node_id = l_est_node_id
236: OR pgn.parent_hierarchy_node_id = l_est_node_id)

Line 285: from per_gen_hierarchy_nodes pgn

281: and l_end_date between asg.effective_start_date and asg.effective_end_date
282: and l_end_date between peo.effective_start_date and peo.effective_end_date
283: and asg.location_id in
284: (select distinct pgn.entity_id
285: from per_gen_hierarchy_nodes pgn
286: where pgn.hierarchy_version_id = p_hierarchy_version_id
287: AND (
288: pgn.hierarchy_node_id = l_est_node_id
289: OR pgn.parent_hierarchy_node_id = l_est_node_id)

Line 336: from per_gen_hierarchy_nodes pgn

332: and l_end_date between asg.effective_start_date and asg.effective_end_date
333: and l_end_date between peo.effective_start_date and peo.effective_end_date
334: and asg.location_id in
335: (select distinct pgn.entity_id
336: from per_gen_hierarchy_nodes pgn
337: where pgn.hierarchy_version_id = p_hierarchy_version_id
338: AND (
339: pgn.hierarchy_node_id = l_est_node_id
340: OR pgn.parent_hierarchy_node_id = l_est_node_id)

Line 387: from per_gen_hierarchy_nodes pgn

383: )
384: and l_end_date between asg.effective_start_date and asg.effective_end_date
385: and asg.location_id in
386: (select distinct pgn.entity_id
387: from per_gen_hierarchy_nodes pgn
388: where pgn.hierarchy_version_id = p_hierarchy_version_id
389: AND (
390: pgn.hierarchy_node_id = l_est_node_id
391: OR pgn.parent_hierarchy_node_id = l_est_node_id)