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 277: l_type per_person_types.system_person_type%TYPE;

273: )
274: is
275:
276: l_proc varchar2(72) := g_package || 'chk_update_allowed';
277: l_type per_person_types.system_person_type%TYPE;
278:
279: -- Cursor to fetch system_person_type for appraisee_person_id
280:
281: cursor csr_fetch_type is

Line 283: from per_person_types ppt

279: -- Cursor to fetch system_person_type for appraisee_person_id
280:
281: cursor csr_fetch_type is
282: select ppt.system_person_type
283: from per_person_types ppt
284: , per_person_type_usages_f ptu
285: , per_all_people_f per
286: where per.person_id = p_rec.appraisee_person_id
287: and p_rec.appraisal_date BETWEEN per.effective_start_date AND per.effective_end_date

Line 1549: l_person_type per_person_types.system_person_type%TYPE;

1545: ,p_person_id in per_all_people_f.person_id%TYPE
1546: ) RETURN boolean IS
1547:
1548: l_exists varchar2(1);
1549: l_person_type per_person_types.system_person_type%TYPE;
1550: l_return boolean;
1551:
1552: -- Cursor to fetch the person_type
1553:

Line 1562: ,per_person_types pt

1558: select pt.system_person_type
1559: from
1560: per_all_people_f per
1561: ,per_person_type_usages_f ptu
1562: ,per_person_types pt
1563: where per.person_id = p_person_id
1564: and p_date BETWEEN per.effective_start_date and per.effective_end_date
1565: AND per.person_id = ptu.person_id
1566: AND p_date between ptu.effective_start_date AND ptu.effective_End_date