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_APR_BUS dependencies on PER_PERSON_TYPES

Line 363: l_type per_person_types.system_person_type%TYPE;

359: )
360: is
361:
362: l_proc varchar2(72) := g_package || 'chk_update_allowed';
363: l_type per_person_types.system_person_type%TYPE;
364: -- Cursor to fetch system_person_type for appraisee_person_id
365: cursor csr_fetch_type is
366: select ppt.system_person_type
367: from per_person_types ppt

Line 367: from per_person_types ppt

363: l_type per_person_types.system_person_type%TYPE;
364: -- Cursor to fetch system_person_type for appraisee_person_id
365: cursor csr_fetch_type is
366: select ppt.system_person_type
367: from per_person_types ppt
368: , per_person_type_usages_f ptu
369: , per_all_people_f per
370: where per.person_id = p_rec.appraisee_person_id
371: and TRUNC(SYSDATE) BETWEEN per.effective_start_date AND per.effective_end_date

Line 1683: l_person_type per_person_types.system_person_type%TYPE;

1679: ,p_future_term IN VARCHAR2
1680: ) RETURN boolean IS
1681:
1682: l_exists varchar2(1);
1683: l_person_type per_person_types.system_person_type%TYPE;
1684: l_return boolean;
1685:
1686: -- Cursor to fetch the person_type
1687:

Line 1696: ,per_person_types pt

1692: select pt.system_person_type
1693: from
1694: per_all_people_f per
1695: ,per_person_type_usages_f ptu
1696: ,per_person_types pt
1697: where per.person_id = p_person_id
1698: and p_date BETWEEN per.effective_start_date and per.effective_end_date
1699: AND per.person_id = ptu.person_id
1700: AND p_date between ptu.effective_start_date AND ptu.effective_End_date