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

Line 227: hr_organization_information hoi1,

223: upper(replace(replace(hoi2.org_information4,'-',''),',','')) duns, --removed hyphens and commas bug 13905482
224: upper(replace(replace(hoi2.org_information3,'-',''),',','')) ein --removed hyphens and commas bug 13905482
225: from per_gen_hierarchy_nodes pgn,
226: hr_all_organization_units hou,
227: hr_organization_information hoi1,
228: hr_organization_information hoi2,
229: hr_locations_all loc
230: where pgn.hierarchy_version_id = p_hierarchy_version_id
231: and pgn.node_type = 'PAR'

Line 228: hr_organization_information hoi2,

224: upper(replace(replace(hoi2.org_information3,'-',''),',','')) ein --removed hyphens and commas bug 13905482
225: from per_gen_hierarchy_nodes pgn,
226: hr_all_organization_units hou,
227: hr_organization_information hoi1,
228: hr_organization_information hoi2,
229: hr_locations_all loc
230: where pgn.hierarchy_version_id = p_hierarchy_version_id
231: and pgn.node_type = 'PAR'
232: and pgn.entity_id = hou.organization_id

Line 248: hr_organization_information hoi1

244: --,upper(replace(hoi2.org_information18,',',' ')) contact_telnum --removed commas bug 13905482
245: ,upper(replace(translate(hoi2.org_information18,'''`;"|\-+=_#$%^&*@!~:<>?/()[]{},.',' '),' ','')) contact_telnum -- removed special characters
246: ,upper(replace(hoi2.org_information20,',',' ')) contact_email --converted to upper case, bug 13905482
247: from
248: hr_organization_information hoi1
249: ,hr_locations_all cloc
250: ,hr_organization_units hou
251: ,hr_organization_information hoi2
252: ,per_gen_hierarchy_nodes pgn

Line 251: ,hr_organization_information hoi2

247: from
248: hr_organization_information hoi1
249: ,hr_locations_all cloc
250: ,hr_organization_units hou
251: ,hr_organization_information hoi2
252: ,per_gen_hierarchy_nodes pgn
253: where
254: hoi1.organization_id = pgn.entity_id
255: and hoi1.org_information_context = 'VETS_Spec'

Line 1212: hr_organization_information hoi1,

1208: hrl.lookup_code lookup_code
1209: from per_periods_of_service pds,
1210: per_all_people_f peo,
1211: per_all_assignments_f ass,
1212: hr_organization_information hoi1,
1213: hr_organization_information hoi2,
1214: per_jobs job,
1215: hr_lookups hrl
1216: where

Line 1213: hr_organization_information hoi2,

1209: from per_periods_of_service pds,
1210: per_all_people_f peo,
1211: per_all_assignments_f ass,
1212: hr_organization_information hoi1,
1213: hr_organization_information hoi2,
1214: per_jobs job,
1215: hr_lookups hrl
1216: where
1217: pds.date_start <= p_end_date

Line 1277: hr_organization_information hoi1,

1273: hrl.lookup_code lookup_code
1274: from per_periods_of_service pds,
1275: per_all_people_f peo,
1276: per_all_assignments_f ass,
1277: hr_organization_information hoi1,
1278: hr_organization_information hoi2,
1279: per_jobs job,
1280: hr_lookups hrl
1281: where

Line 1278: hr_organization_information hoi2,

1274: from per_periods_of_service pds,
1275: per_all_people_f peo,
1276: per_all_assignments_f ass,
1277: hr_organization_information hoi1,
1278: hr_organization_information hoi2,
1279: per_jobs job,
1280: hr_lookups hrl
1281: where
1282: pds.date_start <= p_end_date

Line 1373: FROM HR_ORGANIZATION_INFORMATION HOI1,

1369: AND months_between (p_end_date,pps.date_start) >= 0
1370: AND peo.effective_start_date = pps.date_start
1371: AND EXISTS (
1372: SELECT 'X'
1373: FROM HR_ORGANIZATION_INFORMATION HOI1,
1374: HR_ORGANIZATION_INFORMATION HOI2
1375: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1376: AND hoi1.org_information_context = 'Reporting Statuses'
1377: AND hoi1.organization_id = p_business_group_id

Line 1374: HR_ORGANIZATION_INFORMATION HOI2

1370: AND peo.effective_start_date = pps.date_start
1371: AND EXISTS (
1372: SELECT 'X'
1373: FROM HR_ORGANIZATION_INFORMATION HOI1,
1374: HR_ORGANIZATION_INFORMATION HOI2
1375: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1376: AND hoi1.org_information_context = 'Reporting Statuses'
1377: AND hoi1.organization_id = p_business_group_id
1378: AND ass.employment_category = hoi2.org_information1

Line 1431: FROM HR_ORGANIZATION_INFORMATION HOI1,

1427: AND months_between (p_end_date,pps.date_start) >= 0
1428: AND peo.effective_start_date = pps.date_start
1429: AND EXISTS (
1430: SELECT 'X'
1431: FROM HR_ORGANIZATION_INFORMATION HOI1,
1432: HR_ORGANIZATION_INFORMATION HOI2
1433: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1434: AND hoi1.org_information_context = 'Reporting Statuses'
1435: AND hoi1.organization_id = p_business_group_id

Line 1432: HR_ORGANIZATION_INFORMATION HOI2

1428: AND peo.effective_start_date = pps.date_start
1429: AND EXISTS (
1430: SELECT 'X'
1431: FROM HR_ORGANIZATION_INFORMATION HOI1,
1432: HR_ORGANIZATION_INFORMATION HOI2
1433: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1434: AND hoi1.org_information_context = 'Reporting Statuses'
1435: AND hoi1.organization_id = p_business_group_id
1436: AND ass.employment_category = hoi2.org_information1

Line 1486: FROM HR_ORGANIZATION_INFORMATION HOI1,

1482: OR parent_hierarchy_node_id = l_hierarchy_node_id
1483: ))
1484: AND EXISTS (
1485: SELECT 'X'
1486: FROM HR_ORGANIZATION_INFORMATION HOI1,
1487: HR_ORGANIZATION_INFORMATION HOI2
1488: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1489: AND hoi1.org_information_context = 'Reporting Statuses'
1490: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1487: HR_ORGANIZATION_INFORMATION HOI2

1483: ))
1484: AND EXISTS (
1485: SELECT 'X'
1486: FROM HR_ORGANIZATION_INFORMATION HOI1,
1487: HR_ORGANIZATION_INFORMATION HOI2
1488: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1489: AND hoi1.org_information_context = 'Reporting Statuses'
1490: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1491: AND paf.employment_category = hoi2.org_information1

Line 1530: FROM HR_ORGANIZATION_INFORMATION HOI1,

1526: ))
1527: AND
1528: ( EXISTS (
1529: SELECT 'X'
1530: FROM HR_ORGANIZATION_INFORMATION HOI1,
1531: HR_ORGANIZATION_INFORMATION HOI2
1532: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1533: AND hoi1.org_information_context = 'Reporting Statuses'
1534: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1531: HR_ORGANIZATION_INFORMATION HOI2

1527: AND
1528: ( EXISTS (
1529: SELECT 'X'
1530: FROM HR_ORGANIZATION_INFORMATION HOI1,
1531: HR_ORGANIZATION_INFORMATION HOI2
1532: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1533: AND hoi1.org_information_context = 'Reporting Statuses'
1534: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1535: AND paf.employment_category = hoi2.org_information1