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

Line 54: from per_person_types typ,

50:
51: cursor cur_person_type (c_person_id in number,
52: c_effective_date in date) is
53: select typ.system_person_type
54: from per_person_types typ,
55: per_all_people_f ppf
56: where ppf.person_id = c_person_id
57: and ppf.person_type_id = typ.person_type_id
58: and c_effective_date between

Line 1458: ,per_person_types ppt

1454: BEGIN
1455: SELECT 1
1456: INTO var
1457: FROM per_all_people_f pap
1458: ,per_person_types ppt
1459: WHERE p_effective_date BETWEEN pap.effective_start_date
1460: AND pap.effective_end_date
1461: AND pap.person_id = p_person_id
1462: AND ppt.system_person_type = 'EMP'