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 164: hr_organization_information hoi1,

160: hoi2.org_information3 ein
161: from --per_gen_hierarchy_nodes pghn,
162: per_gen_hierarchy_nodes pgn,
163: hr_organization_units hou,
164: hr_organization_information hoi1,
165: hr_organization_information hoi2,
166: hr_locations_all loc
167: where pgn.hierarchy_version_id = p_hierarchy_version_id
168: and pgn.node_type = 'PAR'

Line 165: hr_organization_information hoi2,

161: from --per_gen_hierarchy_nodes pghn,
162: per_gen_hierarchy_nodes pgn,
163: hr_organization_units hou,
164: hr_organization_information hoi1,
165: hr_organization_information hoi2,
166: hr_locations_all loc
167: where pgn.hierarchy_version_id = p_hierarchy_version_id
168: and pgn.node_type = 'PAR'
169: and pgn.entity_id = hou.organization_id

Line 200: hr_organization_information hoi1,

196: hoi2.org_information3 ein
197: from per_gen_hierarchy_nodes pgn,
198: hr_all_organization_units hou, -- vik
199: -- hr_organization_units hou, -- vik
200: hr_organization_information hoi1,
201: hr_organization_information hoi2,
202: hr_locations_all loc
203: where pgn.hierarchy_version_id = p_hierarchy_version_id
204: and pgn.node_type = 'PAR'

Line 201: hr_organization_information hoi2,

197: from per_gen_hierarchy_nodes pgn,
198: hr_all_organization_units hou, -- vik
199: -- hr_organization_units hou, -- vik
200: hr_organization_information hoi1,
201: hr_organization_information hoi2,
202: hr_locations_all loc
203: where pgn.hierarchy_version_id = p_hierarchy_version_id
204: and pgn.node_type = 'PAR'
205: and pgn.entity_id = hou.organization_id

Line 980: hr_organization_information hoi1,

976: hrl.lookup_code
977: from per_periods_of_service pds,
978: per_people_f peo,
979: per_assignments_f ass,
980: hr_organization_information hoi1,
981: hr_organization_information hoi2,
982: per_jobs job,
983: hr_lookups hrl
984: where (pds.date_start <= p_end_date

Line 981: hr_organization_information hoi2,

977: from per_periods_of_service pds,
978: per_people_f peo,
979: per_assignments_f ass,
980: hr_organization_information hoi1,
981: hr_organization_information hoi2,
982: per_jobs job,
983: hr_lookups hrl
984: where (pds.date_start <= p_end_date
985: and nvl(pds.actual_termination_date,hr_api.g_eot) >= p_end_date

Line 1059: hr_organization_information hoi1,

1055: decode(hrl.lookup_code,10,1,hrl.lookup_code) lookup_code
1056: from per_periods_of_service pds,
1057: per_all_people_f peo,
1058: per_all_assignments_f ass,
1059: hr_organization_information hoi1,
1060: hr_organization_information hoi2,
1061: per_jobs job,
1062: hr_lookups hrl
1063: where

Line 1060: hr_organization_information hoi2,

1056: from per_periods_of_service pds,
1057: per_all_people_f peo,
1058: per_all_assignments_f ass,
1059: hr_organization_information hoi1,
1060: hr_organization_information hoi2,
1061: per_jobs job,
1062: hr_lookups hrl
1063: where
1064: pds.date_start <= p_end_date

Line 1144: hr_organization_information hoi1,

1140: hrl.lookup_code
1141: from per_periods_of_service pds,
1142: per_people_f peo,
1143: per_assignments_f ass,
1144: hr_organization_information hoi1,
1145: hr_organization_information hoi2,
1146: per_jobs job,
1147: hr_lookups hrl
1148: where peo.person_id = ass.person_id

Line 1145: hr_organization_information hoi2,

1141: from per_periods_of_service pds,
1142: per_people_f peo,
1143: per_assignments_f ass,
1144: hr_organization_information hoi1,
1145: hr_organization_information hoi2,
1146: per_jobs job,
1147: hr_lookups hrl
1148: where peo.person_id = ass.person_id
1149: and peo.current_employee_flag = 'Y'

Line 1250: FROM HR_ORGANIZATION_INFORMATION HOI1,

1246: AND months_between (p_end_date,pps.date_start) >= 0
1247: AND peo.effective_start_date = pps.date_start
1248: AND EXISTS (
1249: SELECT 'X'
1250: FROM HR_ORGANIZATION_INFORMATION HOI1,
1251: HR_ORGANIZATION_INFORMATION HOI2
1252: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1253: AND hoi1.org_information_context = 'Reporting Statuses'
1254: AND hoi1.organization_id = p_business_group_id

Line 1251: HR_ORGANIZATION_INFORMATION HOI2

1247: AND peo.effective_start_date = pps.date_start
1248: AND EXISTS (
1249: SELECT 'X'
1250: FROM HR_ORGANIZATION_INFORMATION HOI1,
1251: HR_ORGANIZATION_INFORMATION HOI2
1252: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1253: AND hoi1.org_information_context = 'Reporting Statuses'
1254: AND hoi1.organization_id = p_business_group_id
1255: AND ass.employment_category = hoi2.org_information1

Line 1302: hr_organization_information hoi1,

1298: /* BUT this doesn't pick up correct emp number 18-FEB-2005
1299: cursor c_min_max is
1300: select count ('x') num_people
1301: from per_all_assignments_f ass,
1302: hr_organization_information hoi1,
1303: hr_organization_information hoi2
1304: where ass.assignment_type = 'e'
1305: and ass.primary_flag = 'y'
1306: and l_month_start_date between ass.effective_start_date and ass.effective_end_date

Line 1303: hr_organization_information hoi2

1299: cursor c_min_max is
1300: select count ('x') num_people
1301: from per_all_assignments_f ass,
1302: hr_organization_information hoi1,
1303: hr_organization_information hoi2
1304: where ass.assignment_type = 'e'
1305: and ass.primary_flag = 'y'
1306: and l_month_start_date between ass.effective_start_date and ass.effective_end_date
1307: and ass.business_group_id = p_business_group_id

Line 1356: FROM HR_ORGANIZATION_INFORMATION HOI1,

1352: OR parent_hierarchy_node_id = l_hierarchy_node_id
1353: ))
1354: AND EXISTS (
1355: SELECT 'X'
1356: FROM HR_ORGANIZATION_INFORMATION HOI1,
1357: HR_ORGANIZATION_INFORMATION HOI2
1358: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1359: AND hoi1.org_information_context = 'Reporting Statuses'
1360: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1357: HR_ORGANIZATION_INFORMATION HOI2

1353: ))
1354: AND EXISTS (
1355: SELECT 'X'
1356: FROM HR_ORGANIZATION_INFORMATION HOI1,
1357: HR_ORGANIZATION_INFORMATION HOI2
1358: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1359: AND hoi1.org_information_context = 'Reporting Statuses'
1360: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1361: AND paf.employment_category = hoi2.org_information1

Line 1396: FROM HR_ORGANIZATION_INFORMATION HOI1,

1392: OR parent_hierarchy_node_id = l_hierarchy_node_id
1393: ))
1394: AND EXISTS (
1395: SELECT 'X'
1396: FROM HR_ORGANIZATION_INFORMATION HOI1,
1397: HR_ORGANIZATION_INFORMATION HOI2
1398: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1399: AND hoi1.org_information_context = 'Reporting Statuses'
1400: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1397: HR_ORGANIZATION_INFORMATION HOI2

1393: ))
1394: AND EXISTS (
1395: SELECT 'X'
1396: FROM HR_ORGANIZATION_INFORMATION HOI1,
1397: HR_ORGANIZATION_INFORMATION HOI2
1398: WHERE TO_CHAR(paf.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1399: AND hoi1.org_information_context = 'Reporting Statuses'
1400: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1401: AND paf.employment_category = hoi2.org_information1