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 1542: per_all_people_f p

1538: , a.region_3
1539: , a.date_from
1540: from per_addresses a,
1541: per_contact_relationships c,
1542: per_all_people_f p
1543: where
1544: c.contact_person_id = p_person_id
1545: and c.person_id = p.person_id
1546: and a.person_id = p.person_id

Line 1835: from per_all_people_f p

1831: , w.phone_number phone_work
1832: , f.phone_number phone_fax
1833: , m.phone_number phone_mobile
1834: , b.phone_number phone_pager
1835: from per_all_people_f p
1836: , per_phones h
1837: , per_phones w
1838: , per_phones f
1839: , per_phones m

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

1845: and w.parent_id (+) = p.person_id
1846: and f.parent_id (+) = p.person_id
1847: and m.parent_id (+) = p.person_id
1848: and b.parent_id (+) = p.person_id
1849: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1850: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1851: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1852: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1853: and b.parent_table (+) = 'PER_ALL_PEOPLE_F'

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

1846: and f.parent_id (+) = p.person_id
1847: and m.parent_id (+) = p.person_id
1848: and b.parent_id (+) = p.person_id
1849: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1850: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1851: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1852: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1853: and b.parent_table (+) = 'PER_ALL_PEOPLE_F'
1854: and h.phone_type (+) = 'H1'

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

1847: and m.parent_id (+) = p.person_id
1848: and b.parent_id (+) = p.person_id
1849: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1850: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1851: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1852: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1853: and b.parent_table (+) = 'PER_ALL_PEOPLE_F'
1854: and h.phone_type (+) = 'H1'
1855: and w.phone_type (+) = 'W1'

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

1848: and b.parent_id (+) = p.person_id
1849: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1850: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1851: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1852: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1853: and b.parent_table (+) = 'PER_ALL_PEOPLE_F'
1854: and h.phone_type (+) = 'H1'
1855: and w.phone_type (+) = 'W1'
1856: and f.phone_type (+) = 'WF'

Line 1853: and b.parent_table (+) = 'PER_ALL_PEOPLE_F'

1849: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1850: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1851: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1852: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1853: and b.parent_table (+) = 'PER_ALL_PEOPLE_F'
1854: and h.phone_type (+) = 'H1'
1855: and w.phone_type (+) = 'W1'
1856: and f.phone_type (+) = 'WF'
1857: and m.phone_type (+) = 'M'

Line 1879: from per_all_people_f p

1875: h.phone_number phone_home
1876: , w.phone_number phone_work
1877: , f.phone_number phone_fax
1878: , m.phone_number phone_mobile
1879: from per_all_people_f p
1880: , per_phones h
1881: , per_phones w
1882: , per_phones f
1883: , per_phones m

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

1890: and h.parent_id (+) = p.person_id
1891: and w.parent_id (+) = p.person_id
1892: and f.parent_id (+) = p.person_id
1893: and m.parent_id (+) = p.person_id
1894: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1895: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1896: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1897: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1898: and h.phone_type (+) = 'H1'

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

1891: and w.parent_id (+) = p.person_id
1892: and f.parent_id (+) = p.person_id
1893: and m.parent_id (+) = p.person_id
1894: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1895: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1896: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1897: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1898: and h.phone_type (+) = 'H1'
1899: and w.phone_type (+) = 'W1'

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

1892: and f.parent_id (+) = p.person_id
1893: and m.parent_id (+) = p.person_id
1894: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1895: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1896: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1897: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1898: and h.phone_type (+) = 'H1'
1899: and w.phone_type (+) = 'W1'
1900: and f.phone_type (+) = 'WF'

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

1893: and m.parent_id (+) = p.person_id
1894: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
1895: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
1896: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
1897: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
1898: and h.phone_type (+) = 'H1'
1899: and w.phone_type (+) = 'W1'
1900: and f.phone_type (+) = 'WF'
1901: and m.phone_type (+) = 'M'