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.HR_CONTINGENT_WORKER_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 1252: from per_person_type_usages_f ptu

1248: IS
1249: select 'Y'
1250: from dual
1251: where exists (select 'Y'
1252: from per_person_type_usages_f ptu
1253: ,per_person_types ppt
1254: where ptu.person_id = p_person_id
1255: and ppt.person_type_id = ptu.person_type_id
1256: and ptu.effective_start_date >= p_effective_date

Line 3265: FROM per_person_type_usages_f ptu,

3261: FOR UPDATE;
3262: --
3263: CURSOR future_person_types IS
3264: SELECT pt.system_person_type
3265: FROM per_person_type_usages_f ptu,
3266: per_person_types pt
3267: WHERE ptu.person_id = p_person_id
3268: AND ptu.person_type_id = pt.person_type_id
3269: AND ptu.effective_start_date > p_actual_termination_date;