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.BEN_WHATIF_ELIG dependencies on PER_PERSON_TYPES

Line 325: from per_person_types

321: and nvl(DATE_END, p_effective_date);
322: --
323: cursor c_per_typ is
324: select person_type_id
325: from per_person_types
326: where business_group_id = p_business_group_id
327: and system_PERSON_TYPE = 'OTHER';
328: --
329: l_person_type_id number;

Line 2555: per_person_types pt,

2551: --
2552: cursor c_get_per_typ is
2553: select pt.system_person_type, ptu.*
2554: from per_all_people_f per,
2555: per_person_types pt,
2556: per_person_type_usages_f ptu
2557: where per.person_id = p_person_id
2558: and per.person_type_id = pt.person_type_id
2559: and per.person_id = ptu.person_id

Line 2570: from per_person_types pt

2566: and nvl(per.effective_end_date, p_effective_date);
2567: --
2568: cursor c_get_desired_per_typ is
2569: select pt.system_person_type
2570: from per_person_types pt
2571: where pt.person_type_id = p_person_type_id
2572: and pt.BUSINESS_GROUP_ID = p_BUSINESS_GROUP_ID
2573: and pt.ACTIVE_FLAG = 'Y';
2574: --