APPS.BEN_EXT_PERSON dependencies on PER_PHONES

Line 1809: , per_phones h

1805: , w.phone_number phone_work
1806: , f.phone_number phone_fax
1807: , m.phone_number phone_mobile
1808: from per_all_people_f p
1809: , per_phones h
1810: , per_phones w
1811: , per_phones f
1812: , per_phones m
1813: where p.person_id = p_person_id

Line 1810: , per_phones w

1806: , f.phone_number phone_fax
1807: , m.phone_number phone_mobile
1808: from per_all_people_f p
1809: , per_phones h
1810: , per_phones w
1811: , per_phones f
1812: , per_phones m
1813: where p.person_id = p_person_id
1814: and p_effective_date between nvl(p.effective_start_date, p_effective_date)

Line 1811: , per_phones f

1807: , m.phone_number phone_mobile
1808: from per_all_people_f p
1809: , per_phones h
1810: , per_phones w
1811: , per_phones f
1812: , per_phones m
1813: where p.person_id = p_person_id
1814: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
1815: and nvl(p.effective_end_date, p_effective_date)

Line 1812: , per_phones m

1808: from per_all_people_f p
1809: , per_phones h
1810: , per_phones w
1811: , per_phones f
1812: , per_phones m
1813: where p.person_id = p_person_id
1814: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
1815: and nvl(p.effective_end_date, p_effective_date)
1816: and h.parent_id (+) = p.person_id

Line 1847: , per_phones h

1843: , w.phone_number phone_work
1844: , f.phone_number phone_fax
1845: , m.phone_number phone_mobile
1846: from per_all_people_f p
1847: , per_phones h
1848: , per_phones w
1849: , per_phones f
1850: , per_phones m
1851: ,per_contact_relationships r

Line 1848: , per_phones w

1844: , f.phone_number phone_fax
1845: , m.phone_number phone_mobile
1846: from per_all_people_f p
1847: , per_phones h
1848: , per_phones w
1849: , per_phones f
1850: , per_phones m
1851: ,per_contact_relationships r
1852: where r.contact_person_id = p_person_id

Line 1849: , per_phones f

1845: , m.phone_number phone_mobile
1846: from per_all_people_f p
1847: , per_phones h
1848: , per_phones w
1849: , per_phones f
1850: , per_phones m
1851: ,per_contact_relationships r
1852: where r.contact_person_id = p_person_id
1853: and r.rltd_per_rsds_w_dsgntr_flag = 'Y'

Line 1850: , per_phones m

1846: from per_all_people_f p
1847: , per_phones h
1848: , per_phones w
1849: , per_phones f
1850: , per_phones m
1851: ,per_contact_relationships r
1852: where r.contact_person_id = p_person_id
1853: and r.rltd_per_rsds_w_dsgntr_flag = 'Y'
1854: and p.person_id = r.person_id