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

Line 792: per_person_types ppt

788: --
789: select count(*)
790: into l_person_types
791: from per_people_f ppf,
792: per_person_types ppt
793: where ppf.person_id = P_PERSON_ID
794: and ppf.effective_end_date >= p_effective_date
795: and ppf.person_type_id = ppt.person_type_id
796: and ( exists

Line 799: per_person_types ppt2

795: and ppf.person_type_id = ppt.person_type_id
796: and ( exists
797: (select null
798: from per_people_f ppf2,
799: per_person_types ppt2
800: where ppf2.person_id = ppf.person_id
801: and ppf2.effective_end_date >= p_effective_date
802: and ppf2.person_type_id = ppt2.person_type_id
803: and ppt2.system_person_type <> ppt.system_person_type