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_SINGLE_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 178: l_reporting_name hr_organization_information.org_information1%type;

174: l_parent_node_id varchar2(20);
175:
176: l_est_no number;
177:
178: l_reporting_name hr_organization_information.org_information1%type;
179: l_company_number hr_organization_information.org_information2%type;
180: l_type_of_rep_org hr_organization_information.org_information3%type;
181: l_parent_address clob;
182: l_parent_city hr_locations_all.town_or_city%type;

Line 179: l_company_number hr_organization_information.org_information2%type;

175:
176: l_est_no number;
177:
178: l_reporting_name hr_organization_information.org_information1%type;
179: l_company_number hr_organization_information.org_information2%type;
180: l_type_of_rep_org hr_organization_information.org_information3%type;
181: l_parent_address clob;
182: l_parent_city hr_locations_all.town_or_city%type;
183: l_parent_county hr_locations_all.region_1%type;

Line 180: l_type_of_rep_org hr_organization_information.org_information3%type;

176: l_est_no number;
177:
178: l_reporting_name hr_organization_information.org_information1%type;
179: l_company_number hr_organization_information.org_information2%type;
180: l_type_of_rep_org hr_organization_information.org_information3%type;
181: l_parent_address clob;
182: l_parent_city hr_locations_all.town_or_city%type;
183: l_parent_county hr_locations_all.region_1%type;
184: l_parent_state hr_locations_all.region_2%type;

Line 186: l_contact_name hr_organization_information.org_information17%type;

182: l_parent_city hr_locations_all.town_or_city%type;
183: l_parent_county hr_locations_all.region_1%type;
184: l_parent_state hr_locations_all.region_2%type;
185: l_parent_zip hr_locations_all.postal_code%type;
186: l_contact_name hr_organization_information.org_information17%type;
187: l_contact_telnum hr_organization_information.org_information18%type;
188: l_contact_email hr_organization_information.org_information20%type;
189: l_contact_telnum_and_email hr_organization_information.org_information20%type;
190:

Line 187: l_contact_telnum hr_organization_information.org_information18%type;

183: l_parent_county hr_locations_all.region_1%type;
184: l_parent_state hr_locations_all.region_2%type;
185: l_parent_zip hr_locations_all.postal_code%type;
186: l_contact_name hr_organization_information.org_information17%type;
187: l_contact_telnum hr_organization_information.org_information18%type;
188: l_contact_email hr_organization_information.org_information20%type;
189: l_contact_telnum_and_email hr_organization_information.org_information20%type;
190:
191: l_def_sic varchar2(20);

Line 188: l_contact_email hr_organization_information.org_information20%type;

184: l_parent_state hr_locations_all.region_2%type;
185: l_parent_zip hr_locations_all.postal_code%type;
186: l_contact_name hr_organization_information.org_information17%type;
187: l_contact_telnum hr_organization_information.org_information18%type;
188: l_contact_email hr_organization_information.org_information20%type;
189: l_contact_telnum_and_email hr_organization_information.org_information20%type;
190:
191: l_def_sic varchar2(20);
192: l_def_naics varchar2(20);

Line 189: l_contact_telnum_and_email hr_organization_information.org_information20%type;

185: l_parent_zip hr_locations_all.postal_code%type;
186: l_contact_name hr_organization_information.org_information17%type;
187: l_contact_telnum hr_organization_information.org_information18%type;
188: l_contact_email hr_organization_information.org_information20%type;
189: l_contact_telnum_and_email hr_organization_information.org_information20%type;
190:
191: l_def_sic varchar2(20);
192: l_def_naics varchar2(20);
193: l_def_gre varchar2(20);

Line 268: FROM HR_ORGANIZATION_INFORMATION HOI1,

264: )
265: AND asg.business_group_id = P_BUSINESS_GROUP_ID
266: AND EXISTS (
267: SELECT 'X'
268: FROM HR_ORGANIZATION_INFORMATION HOI1,
269: HR_ORGANIZATION_INFORMATION HOI2
270: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
271: AND hoi1.org_information_context = 'Reporting Statuses'
272: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 269: HR_ORGANIZATION_INFORMATION HOI2

265: AND asg.business_group_id = P_BUSINESS_GROUP_ID
266: AND EXISTS (
267: SELECT 'X'
268: FROM HR_ORGANIZATION_INFORMATION HOI1,
269: HR_ORGANIZATION_INFORMATION HOI2
270: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
271: AND hoi1.org_information_context = 'Reporting Statuses'
272: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
273: AND asg.employment_category = hoi2.org_information1

Line 413: FROM HR_ORGANIZATION_INFORMATION HOI1,

409: and peo2.current_employee_flag = 'Y'
410: and peo2.effective_start_date <= l_month_end_date)
411: AND EXISTS (
412: SELECT 'X'
413: FROM HR_ORGANIZATION_INFORMATION HOI1,
414: HR_ORGANIZATION_INFORMATION HOI2
415: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
416: AND hoi1.org_information_context = 'Reporting Statuses'
417: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 414: HR_ORGANIZATION_INFORMATION HOI2

410: and peo2.effective_start_date <= l_month_end_date)
411: AND EXISTS (
412: SELECT 'X'
413: FROM HR_ORGANIZATION_INFORMATION HOI1,
414: HR_ORGANIZATION_INFORMATION HOI2
415: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
416: AND hoi1.org_information_context = 'Reporting Statuses'
417: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
418: AND asg.employment_category = hoi2.org_information1

Line 465: FROM HR_ORGANIZATION_INFORMATION HOI1,

461: and peo2.current_employee_flag = 'Y'
462: and peo2.effective_start_date <= l_month_end_date)
463: AND EXISTS (
464: SELECT 'X'
465: FROM HR_ORGANIZATION_INFORMATION HOI1,
466: HR_ORGANIZATION_INFORMATION HOI2
467: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
468: AND hoi1.org_information_context = 'Reporting Statuses'
469: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 466: HR_ORGANIZATION_INFORMATION HOI2

462: and peo2.effective_start_date <= l_month_end_date)
463: AND EXISTS (
464: SELECT 'X'
465: FROM HR_ORGANIZATION_INFORMATION HOI1,
466: HR_ORGANIZATION_INFORMATION HOI2
467: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
468: AND hoi1.org_information_context = 'Reporting Statuses'
469: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
470: AND asg.employment_category = hoi2.org_information1

Line 520: FROM HR_ORGANIZATION_INFORMATION HOI1,

516: AND months_between (l_month_end_date,pps.date_start) >= 0
517: AND peo.effective_start_date = pps.date_start
518: AND EXISTS (
519: SELECT 'X'
520: FROM HR_ORGANIZATION_INFORMATION HOI1,
521: HR_ORGANIZATION_INFORMATION HOI2
522: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
523: AND hoi1.org_information_context = 'Reporting Statuses'
524: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 521: HR_ORGANIZATION_INFORMATION HOI2

517: AND peo.effective_start_date = pps.date_start
518: AND EXISTS (
519: SELECT 'X'
520: FROM HR_ORGANIZATION_INFORMATION HOI1,
521: HR_ORGANIZATION_INFORMATION HOI2
522: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
523: AND hoi1.org_information_context = 'Reporting Statuses'
524: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
525: AND asg.employment_category = hoi2.org_information1

Line 570: FROM HR_ORGANIZATION_INFORMATION HOI1,

566: AND months_between (l_month_end_date,pps.date_start) >= 0
567: AND peo.effective_start_date = pps.date_start
568: AND EXISTS (
569: SELECT 'X'
570: FROM HR_ORGANIZATION_INFORMATION HOI1,
571: HR_ORGANIZATION_INFORMATION HOI2
572: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
573: AND hoi1.org_information_context = 'Reporting Statuses'
574: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 571: HR_ORGANIZATION_INFORMATION HOI2

567: AND peo.effective_start_date = pps.date_start
568: AND EXISTS (
569: SELECT 'X'
570: FROM HR_ORGANIZATION_INFORMATION HOI1,
571: HR_ORGANIZATION_INFORMATION HOI2
572: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
573: AND hoi1.org_information_context = 'Reporting Statuses'
574: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
575: AND asg.employment_category = hoi2.org_information1

Line 630: FROM HR_ORGANIZATION_INFORMATION HOI1,

626: AND months_between(l_month_end_date,pps.date_start) >= 0
627: AND peo.effective_start_date = pps.date_start
628: AND EXISTS (
629: SELECT 'X'
630: FROM HR_ORGANIZATION_INFORMATION HOI1,
631: HR_ORGANIZATION_INFORMATION HOI2
632: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
633: AND hoi1.org_information_context = 'Reporting Statuses'
634: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 631: HR_ORGANIZATION_INFORMATION HOI2

627: AND peo.effective_start_date = pps.date_start
628: AND EXISTS (
629: SELECT 'X'
630: FROM HR_ORGANIZATION_INFORMATION HOI1,
631: HR_ORGANIZATION_INFORMATION HOI2
632: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
633: AND hoi1.org_information_context = 'Reporting Statuses'
634: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
635: AND asg.employment_category = hoi2.org_information1

Line 684: FROM HR_ORGANIZATION_INFORMATION HOI1,

680: AND months_between(l_month_end_date,pps.date_start) >= 0
681: AND peo.effective_start_date = pps.date_start
682: AND EXISTS (
683: SELECT 'X'
684: FROM HR_ORGANIZATION_INFORMATION HOI1,
685: HR_ORGANIZATION_INFORMATION HOI2
686: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
687: AND hoi1.org_information_context = 'Reporting Statuses'
688: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 685: HR_ORGANIZATION_INFORMATION HOI2

681: AND peo.effective_start_date = pps.date_start
682: AND EXISTS (
683: SELECT 'X'
684: FROM HR_ORGANIZATION_INFORMATION HOI1,
685: HR_ORGANIZATION_INFORMATION HOI2
686: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
687: AND hoi1.org_information_context = 'Reporting Statuses'
688: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
689: AND asg.employment_category = hoi2.org_information1

Line 749: FROM HR_ORGANIZATION_INFORMATION HOI1,

745: and peo2.current_employee_flag = 'Y'
746: and peo2.effective_start_date <= l_month_end_date)
747: AND EXISTS (
748: SELECT 'X'
749: FROM HR_ORGANIZATION_INFORMATION HOI1,
750: HR_ORGANIZATION_INFORMATION HOI2
751: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
752: AND hoi1.org_information_context = 'Reporting Statuses'
753: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 750: HR_ORGANIZATION_INFORMATION HOI2

746: and peo2.effective_start_date <= l_month_end_date)
747: AND EXISTS (
748: SELECT 'X'
749: FROM HR_ORGANIZATION_INFORMATION HOI1,
750: HR_ORGANIZATION_INFORMATION HOI2
751: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
752: AND hoi1.org_information_context = 'Reporting Statuses'
753: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
754: AND asg.employment_category = hoi2.org_information1

Line 805: FROM HR_ORGANIZATION_INFORMATION HOI1,

801: and peo2.current_employee_flag = 'Y'
802: and peo2.effective_start_date <= l_month_end_date)
803: AND EXISTS (
804: SELECT 'X'
805: FROM HR_ORGANIZATION_INFORMATION HOI1,
806: HR_ORGANIZATION_INFORMATION HOI2
807: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
808: AND hoi1.org_information_context = 'Reporting Statuses'
809: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 806: HR_ORGANIZATION_INFORMATION HOI2

802: and peo2.effective_start_date <= l_month_end_date)
803: AND EXISTS (
804: SELECT 'X'
805: FROM HR_ORGANIZATION_INFORMATION HOI1,
806: HR_ORGANIZATION_INFORMATION HOI2
807: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
808: AND hoi1.org_information_context = 'Reporting Statuses'
809: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
810: AND asg.employment_category = hoi2.org_information1

Line 861: FROM HR_ORGANIZATION_INFORMATION HOI1,

857: and peo2.current_employee_flag = 'Y'
858: and peo2.effective_start_date <= l_month_end_date)
859: AND EXISTS (
860: SELECT 'X'
861: FROM HR_ORGANIZATION_INFORMATION HOI1,
862: HR_ORGANIZATION_INFORMATION HOI2
863: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
864: AND hoi1.org_information_context = 'Reporting Statuses'
865: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 862: HR_ORGANIZATION_INFORMATION HOI2

858: and peo2.effective_start_date <= l_month_end_date)
859: AND EXISTS (
860: SELECT 'X'
861: FROM HR_ORGANIZATION_INFORMATION HOI1,
862: HR_ORGANIZATION_INFORMATION HOI2
863: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
864: AND hoi1.org_information_context = 'Reporting Statuses'
865: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
866: AND asg.employment_category = hoi2.org_information1

Line 916: FROM HR_ORGANIZATION_INFORMATION HOI1,

912: and peo2.current_employee_flag = 'Y'
913: and peo2.effective_start_date <= l_month_end_date)
914: AND EXISTS (
915: SELECT 'X'
916: FROM HR_ORGANIZATION_INFORMATION HOI1,
917: HR_ORGANIZATION_INFORMATION HOI2
918: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
919: AND hoi1.org_information_context = 'Reporting Statuses'
920: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 917: HR_ORGANIZATION_INFORMATION HOI2

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

Line 1293: FROM HR_ORGANIZATION_INFORMATION HOI1,

1289: and
1290: (
1291: exists (
1292: SELECT 'X'
1293: FROM HR_ORGANIZATION_INFORMATION HOI1,
1294: HR_ORGANIZATION_INFORMATION HOI2
1295: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1296: AND hoi1.org_information_context = 'Reporting Statuses'
1297: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1294: HR_ORGANIZATION_INFORMATION HOI2

1290: (
1291: exists (
1292: SELECT 'X'
1293: FROM HR_ORGANIZATION_INFORMATION HOI1,
1294: HR_ORGANIZATION_INFORMATION HOI2
1295: WHERE TO_CHAR(asg.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1296: AND hoi1.org_information_context = 'Reporting Statuses'
1297: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1298: AND asg.employment_category = hoi2.org_information1