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

Line 179: hr_organization_information hoi1,

175: hoi2.org_information3 ein
176: from --per_gen_hierarchy_nodes pghn,
177: per_gen_hierarchy_nodes pgn,
178: hr_organization_units hou,
179: hr_organization_information hoi1,
180: hr_organization_information hoi2,
181: hr_locations_all loc
182: where pgn.hierarchy_version_id = p_hierarchy_version_id
183: and pgn.node_type = 'PAR'

Line 180: hr_organization_information hoi2,

176: from --per_gen_hierarchy_nodes pghn,
177: per_gen_hierarchy_nodes pgn,
178: hr_organization_units hou,
179: hr_organization_information hoi1,
180: hr_organization_information hoi2,
181: hr_locations_all loc
182: where pgn.hierarchy_version_id = p_hierarchy_version_id
183: and pgn.node_type = 'PAR'
184: and pgn.entity_id = hou.organization_id

Line 214: hr_organization_information hoi1,

210: upper(replace(replace(hoi2.org_information3,'-',''),',','')) ein --bug 13905482
211: from per_gen_hierarchy_nodes pgn,
212: hr_all_organization_units hou, -- vik
213: -- hr_organization_units hou, -- vik
214: hr_organization_information hoi1,
215: hr_organization_information hoi2,
216: hr_locations_all loc
217: where pgn.hierarchy_version_id = p_hierarchy_version_id
218: and pgn.node_type = 'PAR'

Line 215: hr_organization_information hoi2,

211: from per_gen_hierarchy_nodes pgn,
212: hr_all_organization_units hou, -- vik
213: -- hr_organization_units hou, -- vik
214: hr_organization_information hoi1,
215: hr_organization_information hoi2,
216: hr_locations_all loc
217: where pgn.hierarchy_version_id = p_hierarchy_version_id
218: and pgn.node_type = 'PAR'
219: and pgn.entity_id = hou.organization_id

Line 238: hr_organization_information hoi1

234: --,upper(replace(hoi2.org_information18,',',' ')) contact_telnum
235: ,upper(replace(translate(hoi2.org_information18,'''`;"|\-+=_#$%^&*@!~:<>?/()[]{},.',' '),' ','')) contact_telnum -- removed special characters
236: ,upper(replace(hoi2.org_information20,',',' ')) contact_email
237: from
238: hr_organization_information hoi1
239: ,hr_locations_all cloc
240: ,hr_organization_units hou
241: ,hr_organization_information hoi2
242: ,per_gen_hierarchy_nodes pgn

Line 241: ,hr_organization_information hoi2

237: from
238: hr_organization_information hoi1
239: ,hr_locations_all cloc
240: ,hr_organization_units hou
241: ,hr_organization_information hoi2
242: ,per_gen_hierarchy_nodes pgn
243: where
244: hoi1.organization_id = pgn.entity_id
245: and hoi1.org_information_context = 'VETS_Spec'

Line 1089: hr_organization_information hoi1,

1085: hrl.lookup_code
1086: from per_periods_of_service pds,
1087: per_people_f peo,
1088: per_assignments_f ass,
1089: hr_organization_information hoi1,
1090: hr_organization_information hoi2,
1091: per_jobs job,
1092: hr_lookups hrl
1093: where (pds.date_start <= p_end_date

Line 1090: hr_organization_information hoi2,

1086: from per_periods_of_service pds,
1087: per_people_f peo,
1088: per_assignments_f ass,
1089: hr_organization_information hoi1,
1090: hr_organization_information hoi2,
1091: per_jobs job,
1092: hr_lookups hrl
1093: where (pds.date_start <= p_end_date
1094: and nvl(pds.actual_termination_date,hr_api.g_eot) >= p_end_date

Line 1173: hr_organization_information hoi1,

1169: decode(hrl.lookup_code,10,1,hrl.lookup_code) lookup_code
1170: from per_periods_of_service pds,
1171: per_all_people_f peo,
1172: per_all_assignments_f ass,
1173: hr_organization_information hoi1,
1174: hr_organization_information hoi2,
1175: per_jobs job,
1176: hr_lookups hrl
1177: where

Line 1174: hr_organization_information hoi2,

1170: from per_periods_of_service pds,
1171: per_all_people_f peo,
1172: per_all_assignments_f ass,
1173: hr_organization_information hoi1,
1174: hr_organization_information hoi2,
1175: per_jobs job,
1176: hr_lookups hrl
1177: where
1178: pds.date_start <= p_end_date

Line 1258: hr_organization_information hoi1,

1254: hrl.lookup_code
1255: from per_periods_of_service pds,
1256: per_people_f peo,
1257: per_assignments_f ass,
1258: hr_organization_information hoi1,
1259: hr_organization_information hoi2,
1260: per_jobs job,
1261: hr_lookups hrl
1262: where peo.person_id = ass.person_id

Line 1259: hr_organization_information hoi2,

1255: from per_periods_of_service pds,
1256: per_people_f peo,
1257: per_assignments_f ass,
1258: hr_organization_information hoi1,
1259: hr_organization_information hoi2,
1260: per_jobs job,
1261: hr_lookups hrl
1262: where peo.person_id = ass.person_id
1263: and peo.current_employee_flag = 'Y'

Line 1366: FROM HR_ORGANIZATION_INFORMATION HOI1,

1362: AND months_between (p_end_date,pps.date_start) >= 0
1363: AND peo.effective_start_date = pps.date_start
1364: AND EXISTS (
1365: SELECT 'X'
1366: FROM HR_ORGANIZATION_INFORMATION HOI1,
1367: HR_ORGANIZATION_INFORMATION HOI2
1368: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1369: AND hoi1.org_information_context = 'Reporting Statuses'
1370: AND hoi1.organization_id = p_business_group_id

Line 1367: HR_ORGANIZATION_INFORMATION HOI2

1363: AND peo.effective_start_date = pps.date_start
1364: AND EXISTS (
1365: SELECT 'X'
1366: FROM HR_ORGANIZATION_INFORMATION HOI1,
1367: HR_ORGANIZATION_INFORMATION HOI2
1368: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1369: AND hoi1.org_information_context = 'Reporting Statuses'
1370: AND hoi1.organization_id = p_business_group_id
1371: AND ass.employment_category = hoi2.org_information1

Line 1418: hr_organization_information hoi1,

1414: /* BUT this doesn't pick up correct emp number 18-FEB-2005
1415: cursor c_min_max is
1416: select count ('x') num_people
1417: from per_all_assignments_f ass,
1418: hr_organization_information hoi1,
1419: hr_organization_information hoi2
1420: where ass.assignment_type = 'e'
1421: and ass.primary_flag = 'y'
1422: and l_month_start_date between ass.effective_start_date and ass.effective_end_date

Line 1419: hr_organization_information hoi2

1415: cursor c_min_max is
1416: select count ('x') num_people
1417: from per_all_assignments_f ass,
1418: hr_organization_information hoi1,
1419: hr_organization_information hoi2
1420: where ass.assignment_type = 'e'
1421: and ass.primary_flag = 'y'
1422: and l_month_start_date between ass.effective_start_date and ass.effective_end_date
1423: and ass.business_group_id = p_business_group_id

Line 1474: FROM HR_ORGANIZATION_INFORMATION HOI1,

1470: OR parent_hierarchy_node_id = l_hierarchy_node_id
1471: ))
1472: AND EXISTS (
1473: SELECT 'X'
1474: FROM HR_ORGANIZATION_INFORMATION HOI1,
1475: HR_ORGANIZATION_INFORMATION HOI2
1476: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1477: AND hoi1.org_information_context = 'Reporting Statuses'
1478: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1475: HR_ORGANIZATION_INFORMATION HOI2

1471: ))
1472: AND EXISTS (
1473: SELECT 'X'
1474: FROM HR_ORGANIZATION_INFORMATION HOI1,
1475: HR_ORGANIZATION_INFORMATION HOI2
1476: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1477: AND hoi1.org_information_context = 'Reporting Statuses'
1478: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1479: AND paf.employment_category = hoi2.org_information1

Line 1518: FROM HR_ORGANIZATION_INFORMATION HOI1,

1514: ))
1515: AND
1516: (EXISTS (
1517: SELECT 'X'
1518: FROM HR_ORGANIZATION_INFORMATION HOI1,
1519: HR_ORGANIZATION_INFORMATION HOI2
1520: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1521: AND hoi1.org_information_context = 'Reporting Statuses'
1522: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1519: HR_ORGANIZATION_INFORMATION HOI2

1515: AND
1516: (EXISTS (
1517: SELECT 'X'
1518: FROM HR_ORGANIZATION_INFORMATION HOI1,
1519: HR_ORGANIZATION_INFORMATION HOI2
1520: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1521: AND hoi1.org_information_context = 'Reporting Statuses'
1522: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1523: AND paf.employment_category = hoi2.org_information1