APPS.HR_CONTACT_RELATIONSHIPS dependencies on PER_PERSON_TYPES_TL

Line 610: ,per_person_types_tl pttl

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

Line 809: from per_person_types_tl pttl,

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