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_EXT_PERSON dependencies on PER_ALL_PEOPLE_F

Line 561: from per_all_people_f p,

557: ,p.per_information28
558: ,p.per_information29
559: ,p.per_information30
560: ,p.business_group_id
561: from per_all_people_f p,
562: per_person_types ppt
563: where
564: p.person_id = p_person_id
565: and p_effective_date between p.effective_start_date

Line 1451: from per_all_people_f

1447: cursor c_sup_info is
1448: select
1449: full_name,
1450: employee_number
1451: from per_all_people_f
1452: where person_id = p_supervisor_id
1453: and p_effective_date between effective_start_date
1454: and effective_end_date ;
1455: begin

Line 1526: per_all_people_f p

1522: , a.region_3
1523: , a.date_from
1524: from per_addresses a,
1525: per_contact_relationships c,
1526: per_all_people_f p
1527: where
1528: c.contact_person_id = p_person_id
1529: and c.person_id = p.person_id
1530: and a.person_id = p.person_id

Line 1808: from per_all_people_f p

1804: h.phone_number phone_home
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

Line 1820: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'

1816: and h.parent_id (+) = p.person_id
1817: and w.parent_id (+) = p.person_id
1818: and f.parent_id (+) = p.person_id
1819: and m.parent_id (+) = p.person_id
1820: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1821: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1822: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1823: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1824: and h.phone_type (+) = 'H1'

Line 1821: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'

1817: and w.parent_id (+) = p.person_id
1818: and f.parent_id (+) = p.person_id
1819: and m.parent_id (+) = p.person_id
1820: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1821: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1822: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1823: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1824: and h.phone_type (+) = 'H1'
1825: and w.phone_type (+) = 'W1'

Line 1822: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'

1818: and f.parent_id (+) = p.person_id
1819: and m.parent_id (+) = p.person_id
1820: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1821: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1822: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1823: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1824: and h.phone_type (+) = 'H1'
1825: and w.phone_type (+) = 'W1'
1826: and f.phone_type (+) = 'WF'

Line 1823: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'

1819: and m.parent_id (+) = p.person_id
1820: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1821: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1822: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1823: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1824: and h.phone_type (+) = 'H1'
1825: and w.phone_type (+) = 'W1'
1826: and f.phone_type (+) = 'WF'
1827: and m.phone_type (+) = 'M'

Line 1846: from per_all_people_f p

1842: h.phone_number phone_home
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

Line 1861: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'

1857: and h.parent_id (+) = p.person_id
1858: and w.parent_id (+) = p.person_id
1859: and f.parent_id (+) = p.person_id
1860: and m.parent_id (+) = p.person_id
1861: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1862: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1863: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1864: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1865: and h.phone_type (+) = 'H1'

Line 1862: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'

1858: and w.parent_id (+) = p.person_id
1859: and f.parent_id (+) = p.person_id
1860: and m.parent_id (+) = p.person_id
1861: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1862: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1863: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1864: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1865: and h.phone_type (+) = 'H1'
1866: and w.phone_type (+) = 'W1'

Line 1863: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'

1859: and f.parent_id (+) = p.person_id
1860: and m.parent_id (+) = p.person_id
1861: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1862: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1863: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1864: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1865: and h.phone_type (+) = 'H1'
1866: and w.phone_type (+) = 'W1'
1867: and f.phone_type (+) = 'WF'

Line 1864: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'

1860: and m.parent_id (+) = p.person_id
1861: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1862: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1863: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1864: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1865: and h.phone_type (+) = 'H1'
1866: and w.phone_type (+) = 'W1'
1867: and f.phone_type (+) = 'WF'
1868: and m.phone_type (+) = 'M'