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_APPLICATIONS_PKG dependencies on PER_PERSON_TYPE_USAGES

Line 1259: FROM PER_PERSON_TYPE_USAGES_F PTU, PER_PERSON_TYPES PPT

1255: WHERE PAPF.PERSON_ID = P_PERSON_ID
1256: AND PAPF.EFFECTIVE_START_DATE > P_DATE_END + 1 ;
1257: cursor c2 is
1258: SELECT 1
1259: FROM PER_PERSON_TYPE_USAGES_F PTU, PER_PERSON_TYPES PPT
1260: WHERE PTU.PERSON_ID = P_PERSON_ID
1261: AND PTU.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
1262: AND PPT.SYSTEM_PERSON_TYPE in ('EMP','CWK')
1263: AND PTU.EFFECTIVE_START_DATE > P_DATE_END + 1 ;

Line 2373: from per_person_type_usages_f ptu

2369:
2370: --changed for 2506446 from the old select
2371: cursor csr_ptu_row is
2372: select ptu.effective_start_date
2373: from per_person_type_usages_f ptu
2374: ,per_person_types ppt
2375: where ptu.person_id = p_person_id
2376: and ptu.effective_start_date > p_date_received
2377: and ptu.person_type_id = ppt.person_type_id

Line 2395: from per_person_type_usages_f ptu

2391: --Bug 3891787 Added the cursor to check for the person_type change
2392: cursor csr_ptu_row1
2393: is
2394: select ptu.person_type_id,ptu.effective_start_date
2395: from per_person_type_usages_f ptu
2396: where ptu.person_id = p_person_id
2397: and p_date_end+1 between ptu.effective_start_date and
2398: ptu.effective_start_date;
2399:

Line 2400: l_person_type_id per_person_type_usages.person_id%type;

2396: where ptu.person_id = p_person_id
2397: and p_date_end+1 between ptu.effective_start_date and
2398: ptu.effective_start_date;
2399:
2400: l_person_type_id per_person_type_usages.person_id%type;
2401: l_start_date date;
2402: l_date_end date;
2403: l_update_mode varchar2(30);
2404:

Line 2450: from per_person_type_usages_f ptu, per_person_types ppt

2446: order by effective_start_date;
2447:
2448: cursor fpt_ptu_apl is
2449: select effective_start_date, ptu.person_type_id
2450: from per_person_type_usages_f ptu, per_person_types ppt
2451: where ptu.person_type_id = ppt.person_type_id
2452: and person_id = p_person_id
2453: and system_person_type in ('APL')
2454: and effective_start_date > p_date_received;

Line 2490: delete from per_person_type_usages_f

2486: for ptu_rec in fpt_ptu_apl loop
2487:
2488: hr_utility.set_location('Cancelling future APL records on PTU on : '||ptu_rec.effective_start_date,12);
2489: l_person_type_id1 := ptu_rec.person_type_id;
2490: delete from per_person_type_usages_f
2491: where person_id = p_person_id
2492: and effective_start_date = ptu_rec.effective_start_date
2493: and person_type_id = l_person_type_id1;
2494: end loop;

Line 2497: update per_person_type_usages_f

2493: and person_type_id = l_person_type_id1;
2494: end loop;
2495:
2496: -- Extending the current APL record till EOT
2497: update per_person_type_usages_f
2498: set effective_end_date = hr_api.g_eot
2499: where person_id = p_person_id
2500: and effective_start_date = p_date_received
2501: and person_type_id = l_person_type_id1;