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.HR_JP_DATA_MIGRATION_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 1853: per_contact_extra_info_f pcei,

1849: select /*+ ORDERED */
1850: pp_c.person_id
1851: from per_all_assignments_f pa,
1852: per_contact_relationships pcr,
1853: per_contact_extra_info_f pcei,
1854: per_all_people_f pp_c
1855: where pa.assignment_id = p_assignment_id
1856: and p_session_date
1857: between pa.effective_start_date and pa.effective_end_date

Line 1891: per_contact_extra_info_f pcei,

1887: select /*+ ORDERED */
1888: pp_c.person_id
1889: from per_all_assignments_f pa,
1890: per_contact_relationships pcr,
1891: per_contact_extra_info_f pcei,
1892: per_all_people_f pp_c
1893: where pa.assignment_id = p_assignment_id
1894: and p_session_date
1895: between pa.effective_start_date and pa.effective_end_date

Line 1917: per_contact_extra_info_f pcei

1913: select /*+ ORDERED */
1914: pcei.contact_extra_info_id
1915: from per_all_assignments_f pa,
1916: per_contact_relationships pcr,
1917: per_contact_extra_info_f pcei
1918: where pa.assignment_id = p_assignment_id
1919: and p_session_date
1920: between pa.effective_start_date and pa.effective_end_date
1921: and pcr.person_id = pa.person_id

Line 1933: per_contact_extra_info_f pcei,

1929: select /*+ ORDERED */
1930: pcei.contact_extra_info_id
1931: from per_all_assignments_f pa,
1932: per_contact_relationships pcr,
1933: per_contact_extra_info_f pcei,
1934: per_all_people_f pp_c
1935: where pa.assignment_id = p_assignment_id
1936: and p_session_date
1937: between pa.effective_start_date and pa.effective_end_date

Line 1957: per_contact_extra_info_f pcei,

1953: select /*+ ORDERED */
1954: pcei.contact_extra_info_id
1955: from per_all_assignments_f pa,
1956: per_contact_relationships pcr,
1957: per_contact_extra_info_f pcei,
1958: per_all_people_f pp_c
1959: where pa.assignment_id = p_assignment_id
1960: and p_session_date
1961: between pa.effective_start_date and pa.effective_end_date

Line 2275: l_dep_type per_contact_extra_info_f.cei_information8%type;

2271: is
2272: --
2273: l_proc varchar2(80) := c_package||'mig_dep_assact';
2274: --
2275: l_dep_type per_contact_extra_info_f.cei_information8%type;
2276: --
2277: l_ee_id number;
2278: --
2279: l_element_link_id number;

Line 2306: per_contact_extra_info_f pcei,

2302: to_char((add_months(trunc(p_session_date,'YYYY'),12) - 1),'YYYY/MM/DD')),'YYYY/MM/DD') + 1,
2303: pp_c.date_of_birth) / 12) c_age
2304: from per_all_assignments_f pa,
2305: per_contact_relationships pcr,
2306: per_contact_extra_info_f pcei,
2307: per_all_people_f pp_c
2308: where pa.assignment_id = p_assignment_id
2309: and p_session_date
2310: between pa.effective_start_date and pa.effective_end_date

Line 2353: per_contact_extra_info_f pcei,

2349: to_char((add_months(trunc(p_session_date,'YYYY'),12) - 1),'YYYY/MM/DD')),'YYYY/MM/DD') + 1,
2350: pp_c.date_of_birth) / 12) c_age
2351: from per_all_assignments_f pa,
2352: per_contact_relationships pcr,
2353: per_contact_extra_info_f pcei,
2354: per_all_people_f pp_c
2355: where pa.assignment_id = p_assignment_id
2356: and p_session_date
2357: between pa.effective_start_date and pa.effective_end_date

Line 2380: per_contact_extra_info_f pcei

2376: select /*+ ORDERED */
2377: pcei.contact_extra_info_id
2378: from per_all_assignments_f pa,
2379: per_contact_relationships pcr,
2380: per_contact_extra_info_f pcei
2381: where pa.assignment_id = p_assignment_id
2382: and p_session_date
2383: between pa.effective_start_date and pa.effective_end_date
2384: and pcr.person_id = pa.person_id