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_RELATIONSHIPS

Line 1852: per_contact_relationships pcr,

1848: is
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

Line 1890: per_contact_relationships pcr,

1886: is
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

Line 1916: per_contact_relationships pcr,

1912: is
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

Line 1932: per_contact_relationships pcr,

1928: is
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

Line 1956: per_contact_relationships pcr,

1952: is
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

Line 2305: per_contact_relationships pcr,

2301: to_char(pp_c.date_of_death,'YYYY/MM/DD'),to_char(pp_c.date_of_death,'YYYY/MM/DD'),
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

Line 2352: per_contact_relationships pcr,

2348: to_char(pp_c.date_of_death,'YYYY/MM/DD'),to_char(pp_c.date_of_death,'YYYY/MM/DD'),
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

Line 2379: per_contact_relationships pcr,

2375: is
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