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 1164: FROM per_person_type_usages_f ptu

1160: CURSOR fpt_ptu_details IS
1161: SELECT ptu.person_type_id
1162: ,effective_start_date
1163: ,effective_end_date
1164: FROM per_person_type_usages_f ptu
1165: ,per_person_types ppt
1166: WHERE person_id = p_person_id
1167: AND effective_start_date > l_effective_date
1168: AND ptu.person_type_id = ppt.person_type_id

Line 1618: from per_person_type_usages_f ptu

1614: IS
1615: select 'Y'
1616: from dual
1617: where exists (select 'Y'
1618: from per_person_type_usages_f ptu
1619: ,per_person_types ppt
1620: where ptu.person_id = p_person_id
1621: and ppt.person_type_id = ptu.person_type_id
1622: and ptu.effective_start_date >= p_effective_date

Line 2175: from per_person_type_usages_f ptu, per_person_types ppt

2171: -- ER FPT
2172: l_start_date date;
2173: cursor csr_fpt_ptu_changes is
2174: select null
2175: from per_person_type_usages_f ptu, per_person_types ppt
2176: where person_id = p_person_id
2177: and effective_start_date > l_actual_termination_date
2178: and ptu.person_type_id = ppt.person_type_id
2179: and ppt.system_person_type in ('EMP','CWK');

Line 3687: FROM per_person_type_usages_f ptu,

3683: FOR UPDATE;
3684: --
3685: CURSOR future_person_types IS
3686: SELECT pt.system_person_type
3687: FROM per_person_type_usages_f ptu,
3688: per_person_types pt
3689: WHERE ptu.person_id = p_person_id
3690: AND ptu.person_type_id = pt.person_type_id
3691: AND ptu.effective_start_date > p_actual_termination_date;