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 HR_ORGANIZATION_INFORMATION

Line 71: hr_organization_information hoi1

67: select
68: l_parent_node_id,
69: hoi1.org_information1 "Par Report Name"
70: from
71: hr_organization_information hoi1
72: where
73: hoi1.organization_id = l_parent_org_id
74: and hoi1.org_information_context = 'VETS_Spec' ;
75:

Line 114: l_reporting_name hr_organization_information.org_information1%type;

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;
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;

Line 160: FROM HR_ORGANIZATION_INFORMATION HOI1,

156: and asg.assignment_type = 'E'
157: and asg.primary_flag = 'Y'
158: and exists (
159: SELECT 'X'
160: FROM HR_ORGANIZATION_INFORMATION HOI1,
161: HR_ORGANIZATION_INFORMATION HOI2
162: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
163: AND hoi1.org_information_context = 'Reporting Statuses'
164: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 161: HR_ORGANIZATION_INFORMATION HOI2

157: and asg.primary_flag = 'Y'
158: and exists (
159: SELECT 'X'
160: FROM HR_ORGANIZATION_INFORMATION HOI1,
161: HR_ORGANIZATION_INFORMATION HOI2
162: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
163: AND hoi1.org_information_context = 'Reporting Statuses'
164: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
165: AND asg.employment_category = hoi2.org_information1

Line 212: FROM HR_ORGANIZATION_INFORMATION HOI1,

208: and asg.assignment_type = 'E'
209: and asg.primary_flag = 'Y'
210: and exists (
211: SELECT 'X'
212: FROM HR_ORGANIZATION_INFORMATION HOI1,
213: HR_ORGANIZATION_INFORMATION HOI2
214: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
215: AND hoi1.org_information_context = 'Reporting Statuses'
216: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 213: HR_ORGANIZATION_INFORMATION HOI2

209: and asg.primary_flag = 'Y'
210: and exists (
211: SELECT 'X'
212: FROM HR_ORGANIZATION_INFORMATION HOI1,
213: HR_ORGANIZATION_INFORMATION HOI2
214: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
215: AND hoi1.org_information_context = 'Reporting Statuses'
216: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
217: AND asg.employment_category = hoi2.org_information1

Line 265: FROM HR_ORGANIZATION_INFORMATION HOI1,

261: and asg.assignment_type = 'E'
262: and asg.primary_flag = 'Y'
263: and exists (
264: SELECT 'X'
265: FROM HR_ORGANIZATION_INFORMATION HOI1,
266: HR_ORGANIZATION_INFORMATION HOI2
267: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
268: AND hoi1.org_information_context = 'Reporting Statuses'
269: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 266: HR_ORGANIZATION_INFORMATION HOI2

262: and asg.primary_flag = 'Y'
263: and exists (
264: SELECT 'X'
265: FROM HR_ORGANIZATION_INFORMATION HOI1,
266: HR_ORGANIZATION_INFORMATION HOI2
267: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
268: AND hoi1.org_information_context = 'Reporting Statuses'
269: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
270: AND asg.employment_category = hoi2.org_information1

Line 316: FROM HR_ORGANIZATION_INFORMATION HOI1,

312: and asg.assignment_type = 'E'
313: and asg.primary_flag = 'Y'
314: and exists (
315: SELECT 'X'
316: FROM HR_ORGANIZATION_INFORMATION HOI1,
317: HR_ORGANIZATION_INFORMATION HOI2
318: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
319: AND hoi1.org_information_context = 'Reporting Statuses'
320: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 317: HR_ORGANIZATION_INFORMATION HOI2

313: and asg.primary_flag = 'Y'
314: and exists (
315: SELECT 'X'
316: FROM HR_ORGANIZATION_INFORMATION HOI1,
317: HR_ORGANIZATION_INFORMATION HOI2
318: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
319: AND hoi1.org_information_context = 'Reporting Statuses'
320: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
321: AND asg.employment_category = hoi2.org_information1

Line 365: FROM HR_ORGANIZATION_INFORMATION HOI1,

361: and
362: (
363: exists (
364: SELECT 'X'
365: FROM HR_ORGANIZATION_INFORMATION HOI1,
366: HR_ORGANIZATION_INFORMATION HOI2
367: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
368: AND hoi1.org_information_context = 'Reporting Statuses'
369: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 366: HR_ORGANIZATION_INFORMATION HOI2

362: (
363: exists (
364: SELECT 'X'
365: FROM HR_ORGANIZATION_INFORMATION HOI1,
366: HR_ORGANIZATION_INFORMATION HOI2
367: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
368: AND hoi1.org_information_context = 'Reporting Statuses'
369: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
370: AND asg.employment_category = hoi2.org_information1