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_LOOKUPS

Line 1092: hr_lookups hrl

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
1095: or pds.date_start between p_start_date and p_end_date
1096: and p_end_date between pds.date_start and nvl(pds.actual_termination_date,hr_api.g_eot))

Line 1176: hr_lookups hrl

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
1179: and nvl(pds.actual_termination_date,p_end_date + 1) >= p_end_date
1180: and pds.person_id = ass.person_id

Line 1261: hr_lookups hrl

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'
1264: and pds.date_start
1265: between p_start_date

Line 1337: hr_lookups hrl,

1333: decode(hrl.lookup_code,'10','1',hrl.lookup_code) lookup_code
1334: FROM per_all_people_f peo,
1335: per_all_assignments_f ass,
1336: per_jobs job,
1337: hr_lookups hrl,
1338: per_periods_of_service pps
1339: WHERE peo.person_id = ass.person_id
1340: AND peo.person_id = pps.person_id
1341: AND peo.business_group_id = p_business_group_id