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_LOOKUPS

Line 1215: hr_lookups hrl

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

Line 1280: hr_lookups hrl

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

Line 1344: hr_lookups hrl,

1340: hrl.lookup_code lookup_code
1341: FROM per_all_people_f peo,
1342: per_all_assignments_f ass,
1343: per_jobs job,
1344: hr_lookups hrl,
1345: per_periods_of_service pps
1346: WHERE peo.person_id = ass.person_id
1347: AND peo.person_id = pps.person_id
1348: AND peo.business_group_id = p_business_group_id

Line 1402: hr_lookups hrl,

1398: hrl.lookup_code lookup_code
1399: FROM per_all_people_f peo,
1400: per_all_assignments_f ass,
1401: per_jobs job,
1402: hr_lookups hrl,
1403: per_periods_of_service pps
1404: WHERE peo.person_id = ass.person_id
1405: AND peo.person_id = pps.person_id
1406: AND peo.business_group_id = p_business_group_id