APPS.HR_CONTACT_RELATIONSHIPS dependencies on PER_PERSON_TYPES_TL

Line 611: ,per_person_types_tl pttl

607: ,per.date_of_death
608: -- fix for bug 4957699 starts here.
609: ,npw_number
610: from hr_lookups t
611: ,per_person_types_tl pttl
612: ,per_person_types pt
613: ,per_all_people_f per
614: where pt.person_type_id = pttl.person_type_id
615: and t.lookup_type(+) = 'TITLE'

Line 811: from per_person_types_tl pttl,

807: CURSOR c is
808: select pt.person_type_id
809: , pttl.user_person_type
810: , pt.system_person_type
811: from per_person_types_tl pttl,
812: per_person_types pt
813: where pt.system_person_type = 'OTHER'
814: and pt.default_flag = 'Y'
815: and pt.active_flag = 'Y'