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_CONS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 83: hr_organization_information hoi1

79: ,substr(hoi2.org_information18,1,20) contact_telnum
80: ,hoi2.org_information20 contact_email
81: ,substr(hoi2.org_information18,1,20) || ' ' ||hoi2.org_information20 contact_telnum_and_email
82: from
83: hr_organization_information hoi1
84: ,hr_locations_all cloc
85: ,hr_organization_units hou
86: ,hr_organization_information hoi2
87: where

Line 86: ,hr_organization_information hoi2

82: from
83: hr_organization_information hoi1
84: ,hr_locations_all cloc
85: ,hr_organization_units hou
86: ,hr_organization_information hoi2
87: where
88: hoi1.organization_id = l_parent_org_id
89: and hoi1.org_information_context = 'VETS_Spec'
90: and hoi1.organization_id = hou.organization_id

Line 103: hr_organization_information

99: ,org_information3
100: ,org_information4
101: ,org_information5
102: from
103: hr_organization_information
104: where
105: organization_id = l_parent_org_id
106: and org_information_context = 'VETS_EEO_Dup' ;
107:

Line 187: FROM HR_ORGANIZATION_INFORMATION HOI1,

183: <= l_month_end_date)
184: AND
185: (EXISTS (
186: SELECT 'X'
187: FROM HR_ORGANIZATION_INFORMATION HOI1,
188: HR_ORGANIZATION_INFORMATION HOI2
189: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
190: AND hoi1.org_information_context = 'Reporting Statuses'
191: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 188: HR_ORGANIZATION_INFORMATION HOI2

184: AND
185: (EXISTS (
186: SELECT 'X'
187: FROM HR_ORGANIZATION_INFORMATION HOI1,
188: HR_ORGANIZATION_INFORMATION HOI2
189: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
190: AND hoi1.org_information_context = 'Reporting Statuses'
191: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
192: AND asg.employment_category = hoi2.org_information1

Line 215: l_reporting_name hr_organization_information.org_information1%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;
216: l_company_number hr_organization_information.org_information2%type;
217: l_type_of_rep_org hr_organization_information.org_information3%type;
218: l_parent_address clob;
219: l_parent_city hr_locations_all.town_or_city%type;

Line 216: l_company_number hr_organization_information.org_information2%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;
216: l_company_number hr_organization_information.org_information2%type;
217: l_type_of_rep_org hr_organization_information.org_information3%type;
218: l_parent_address clob;
219: l_parent_city hr_locations_all.town_or_city%type;
220: l_parent_county hr_locations_all.region_1%type;

Line 217: l_type_of_rep_org hr_organization_information.org_information3%type;

213: l_parent_node_id varchar2(20);
214:
215: l_reporting_name hr_organization_information.org_information1%type;
216: l_company_number hr_organization_information.org_information2%type;
217: l_type_of_rep_org hr_organization_information.org_information3%type;
218: l_parent_address clob;
219: l_parent_city hr_locations_all.town_or_city%type;
220: l_parent_county hr_locations_all.region_1%type;
221: l_parent_state hr_locations_all.region_2%type;

Line 223: l_contact_name hr_organization_information.org_information17%type;

219: l_parent_city hr_locations_all.town_or_city%type;
220: l_parent_county hr_locations_all.region_1%type;
221: l_parent_state hr_locations_all.region_2%type;
222: l_parent_zip hr_locations_all.postal_code%type;
223: l_contact_name hr_organization_information.org_information17%type;
224: l_contact_telnum hr_organization_information.org_information18%type;
225: l_contact_email hr_organization_information.org_information20%type;
226: l_contact_telnum_and_email hr_organization_information.org_information20%type;
227:

Line 224: l_contact_telnum hr_organization_information.org_information18%type;

220: l_parent_county hr_locations_all.region_1%type;
221: l_parent_state hr_locations_all.region_2%type;
222: l_parent_zip hr_locations_all.postal_code%type;
223: l_contact_name hr_organization_information.org_information17%type;
224: l_contact_telnum hr_organization_information.org_information18%type;
225: l_contact_email hr_organization_information.org_information20%type;
226: l_contact_telnum_and_email hr_organization_information.org_information20%type;
227:
228: l_state hr_locations_all.region_2%type;

Line 225: l_contact_email hr_organization_information.org_information20%type;

221: l_parent_state hr_locations_all.region_2%type;
222: l_parent_zip hr_locations_all.postal_code%type;
223: l_contact_name hr_organization_information.org_information17%type;
224: l_contact_telnum hr_organization_information.org_information18%type;
225: l_contact_email hr_organization_information.org_information20%type;
226: l_contact_telnum_and_email hr_organization_information.org_information20%type;
227:
228: l_state hr_locations_all.region_2%type;
229: l_state_meaning varchar2(20);

Line 226: l_contact_telnum_and_email hr_organization_information.org_information20%type;

222: l_parent_zip hr_locations_all.postal_code%type;
223: l_contact_name hr_organization_information.org_information17%type;
224: l_contact_telnum hr_organization_information.org_information18%type;
225: l_contact_email hr_organization_information.org_information20%type;
226: l_contact_telnum_and_email hr_organization_information.org_information20%type;
227:
228: l_state hr_locations_all.region_2%type;
229: l_state_meaning varchar2(20);
230:

Line 339: FROM HR_ORGANIZATION_INFORMATION HOI1,

335: and asg.business_group_id = P_BUSINESS_GROUP_ID
336: AND
337: ( EXISTS (
338: SELECT 'X'
339: FROM HR_ORGANIZATION_INFORMATION HOI1,
340: HR_ORGANIZATION_INFORMATION HOI2
341: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
342: AND hoi1.org_information_context = 'Reporting Statuses'
343: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 340: HR_ORGANIZATION_INFORMATION HOI2

336: AND
337: ( EXISTS (
338: SELECT 'X'
339: FROM HR_ORGANIZATION_INFORMATION HOI1,
340: HR_ORGANIZATION_INFORMATION HOI2
341: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
342: AND hoi1.org_information_context = 'Reporting Statuses'
343: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
344: AND asg.employment_category = hoi2.org_information1

Line 394: FROM HR_ORGANIZATION_INFORMATION HOI1,

390: <= l_month_end_date)
391: and asg.business_group_id = P_BUSINESS_GROUP_ID
392: AND EXISTS (
393: SELECT 'X'
394: FROM HR_ORGANIZATION_INFORMATION HOI1,
395: HR_ORGANIZATION_INFORMATION HOI2
396: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
397: AND hoi1.org_information_context = 'Reporting Statuses'
398: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 395: HR_ORGANIZATION_INFORMATION HOI2

391: and asg.business_group_id = P_BUSINESS_GROUP_ID
392: AND EXISTS (
393: SELECT 'X'
394: FROM HR_ORGANIZATION_INFORMATION HOI1,
395: HR_ORGANIZATION_INFORMATION HOI2
396: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
397: AND hoi1.org_information_context = 'Reporting Statuses'
398: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
399: AND asg.employment_category = hoi2.org_information1

Line 556: FROM HR_ORGANIZATION_INFORMATION HOI1,

552: and peo.business_group_id = P_BUSINESS_GROUP_ID
553: and job.business_group_id = P_BUSINESS_GROUP_ID
554: AND EXISTS (
555: SELECT 'X'
556: FROM HR_ORGANIZATION_INFORMATION HOI1,
557: HR_ORGANIZATION_INFORMATION HOI2
558: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
559: AND hoi1.org_information_context = 'Reporting Statuses'
560: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 557: HR_ORGANIZATION_INFORMATION HOI2

553: and job.business_group_id = P_BUSINESS_GROUP_ID
554: AND EXISTS (
555: SELECT 'X'
556: FROM HR_ORGANIZATION_INFORMATION HOI1,
557: HR_ORGANIZATION_INFORMATION HOI2
558: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
559: AND hoi1.org_information_context = 'Reporting Statuses'
560: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
561: AND asg.employment_category = hoi2.org_information1

Line 616: FROM HR_ORGANIZATION_INFORMATION HOI1,

612: and peo.business_group_id = P_BUSINESS_GROUP_ID
613: and job.business_group_id = P_BUSINESS_GROUP_ID
614: AND EXISTS (
615: SELECT 'X'
616: FROM HR_ORGANIZATION_INFORMATION HOI1,
617: HR_ORGANIZATION_INFORMATION HOI2
618: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
619: AND hoi1.org_information_context = 'Reporting Statuses'
620: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 617: HR_ORGANIZATION_INFORMATION HOI2

613: and job.business_group_id = P_BUSINESS_GROUP_ID
614: AND EXISTS (
615: SELECT 'X'
616: FROM HR_ORGANIZATION_INFORMATION HOI1,
617: HR_ORGANIZATION_INFORMATION HOI2
618: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
619: AND hoi1.org_information_context = 'Reporting Statuses'
620: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
621: AND asg.employment_category = hoi2.org_information1

Line 677: FROM HR_ORGANIZATION_INFORMATION HOI1,

673: AND peo.effective_start_date = pps.date_start
674:
675: AND EXISTS (
676: SELECT 'X'
677: FROM HR_ORGANIZATION_INFORMATION HOI1,
678: HR_ORGANIZATION_INFORMATION HOI2
679: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
680: AND hoi1.org_information_context = 'Reporting Statuses'
681: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 678: HR_ORGANIZATION_INFORMATION HOI2

674:
675: AND EXISTS (
676: SELECT 'X'
677: FROM HR_ORGANIZATION_INFORMATION HOI1,
678: HR_ORGANIZATION_INFORMATION HOI2
679: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
680: AND hoi1.org_information_context = 'Reporting Statuses'
681: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
682: AND asg.employment_category = hoi2.org_information1

Line 737: FROM HR_ORGANIZATION_INFORMATION HOI1,

733: AND peo.effective_start_date = pps.date_start
734:
735: AND EXISTS (
736: SELECT 'X'
737: FROM HR_ORGANIZATION_INFORMATION HOI1,
738: HR_ORGANIZATION_INFORMATION HOI2
739: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
740: AND hoi1.org_information_context = 'Reporting Statuses'
741: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 738: HR_ORGANIZATION_INFORMATION HOI2

734:
735: AND EXISTS (
736: SELECT 'X'
737: FROM HR_ORGANIZATION_INFORMATION HOI1,
738: HR_ORGANIZATION_INFORMATION HOI2
739: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
740: AND hoi1.org_information_context = 'Reporting Statuses'
741: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
742: AND asg.employment_category = hoi2.org_information1

Line 803: FROM HR_ORGANIZATION_INFORMATION HOI1,

799: and peo.business_group_id = P_BUSINESS_GROUP_ID
800: and job.business_group_id = P_BUSINESS_GROUP_ID
801: AND EXISTS (
802: SELECT 'X'
803: FROM HR_ORGANIZATION_INFORMATION HOI1,
804: HR_ORGANIZATION_INFORMATION HOI2
805: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
806: AND hoi1.org_information_context = 'Reporting Statuses'
807: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 804: HR_ORGANIZATION_INFORMATION HOI2

800: and job.business_group_id = P_BUSINESS_GROUP_ID
801: AND EXISTS (
802: SELECT 'X'
803: FROM HR_ORGANIZATION_INFORMATION HOI1,
804: HR_ORGANIZATION_INFORMATION HOI2
805: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
806: AND hoi1.org_information_context = 'Reporting Statuses'
807: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
808: AND asg.employment_category = hoi2.org_information1

Line 858: FROM HR_ORGANIZATION_INFORMATION HOI1,

854: and peo.business_group_id = P_BUSINESS_GROUP_ID
855: and job.business_group_id = P_BUSINESS_GROUP_ID
856: AND EXISTS (
857: SELECT 'X'
858: FROM HR_ORGANIZATION_INFORMATION HOI1,
859: HR_ORGANIZATION_INFORMATION HOI2
860: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
861: AND hoi1.org_information_context = 'Reporting Statuses'
862: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 859: HR_ORGANIZATION_INFORMATION HOI2

855: and job.business_group_id = P_BUSINESS_GROUP_ID
856: AND EXISTS (
857: SELECT 'X'
858: FROM HR_ORGANIZATION_INFORMATION HOI1,
859: HR_ORGANIZATION_INFORMATION HOI2
860: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
861: AND hoi1.org_information_context = 'Reporting Statuses'
862: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
863: AND asg.employment_category = hoi2.org_information1

Line 917: FROM HR_ORGANIZATION_INFORMATION HOI1,

913: AND months_between (l_month_end_date,pps.date_start) >= 0
914: AND peo.effective_start_date = pps.date_start
915: AND EXISTS (
916: SELECT 'X'
917: FROM HR_ORGANIZATION_INFORMATION HOI1,
918: HR_ORGANIZATION_INFORMATION HOI2
919: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
920: AND hoi1.org_information_context = 'Reporting Statuses'
921: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 918: HR_ORGANIZATION_INFORMATION HOI2

914: AND peo.effective_start_date = pps.date_start
915: AND EXISTS (
916: SELECT 'X'
917: FROM HR_ORGANIZATION_INFORMATION HOI1,
918: HR_ORGANIZATION_INFORMATION HOI2
919: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
920: AND hoi1.org_information_context = 'Reporting Statuses'
921: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
922: AND asg.employment_category = hoi2.org_information1

Line 971: FROM HR_ORGANIZATION_INFORMATION HOI1,

967: AND months_between (l_month_end_date,pps.date_start) >= 0
968: AND peo.effective_start_date = pps.date_start
969: AND EXISTS (
970: SELECT 'X'
971: FROM HR_ORGANIZATION_INFORMATION HOI1,
972: HR_ORGANIZATION_INFORMATION HOI2
973: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
974: AND hoi1.org_information_context = 'Reporting Statuses'
975: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 972: HR_ORGANIZATION_INFORMATION HOI2

968: AND peo.effective_start_date = pps.date_start
969: AND EXISTS (
970: SELECT 'X'
971: FROM HR_ORGANIZATION_INFORMATION HOI1,
972: HR_ORGANIZATION_INFORMATION HOI2
973: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
974: AND hoi1.org_information_context = 'Reporting Statuses'
975: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
976: AND asg.employment_category = hoi2.org_information1

Line 1035: FROM HR_ORGANIZATION_INFORMATION HOI1,

1031: and peo.business_group_id = P_BUSINESS_GROUP_ID
1032: and job.business_group_id = P_BUSINESS_GROUP_ID
1033: AND EXISTS (
1034: SELECT 'X'
1035: FROM HR_ORGANIZATION_INFORMATION HOI1,
1036: HR_ORGANIZATION_INFORMATION HOI2
1037: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1038: AND hoi1.org_information_context = 'Reporting Statuses'
1039: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1036: HR_ORGANIZATION_INFORMATION HOI2

1032: and job.business_group_id = P_BUSINESS_GROUP_ID
1033: AND EXISTS (
1034: SELECT 'X'
1035: FROM HR_ORGANIZATION_INFORMATION HOI1,
1036: HR_ORGANIZATION_INFORMATION HOI2
1037: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1038: AND hoi1.org_information_context = 'Reporting Statuses'
1039: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1040: AND asg.employment_category = hoi2.org_information1

Line 1094: FROM HR_ORGANIZATION_INFORMATION HOI1,

1090: and peo.business_group_id = P_BUSINESS_GROUP_ID
1091: and job.business_group_id = P_BUSINESS_GROUP_ID
1092: AND EXISTS (
1093: SELECT 'X'
1094: FROM HR_ORGANIZATION_INFORMATION HOI1,
1095: HR_ORGANIZATION_INFORMATION HOI2
1096: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1097: AND hoi1.org_information_context = 'Reporting Statuses'
1098: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1095: HR_ORGANIZATION_INFORMATION HOI2

1091: and job.business_group_id = P_BUSINESS_GROUP_ID
1092: AND EXISTS (
1093: SELECT 'X'
1094: FROM HR_ORGANIZATION_INFORMATION HOI1,
1095: HR_ORGANIZATION_INFORMATION HOI2
1096: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1097: AND hoi1.org_information_context = 'Reporting Statuses'
1098: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1099: AND asg.employment_category = hoi2.org_information1