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_ALL_PEOPLE_F

Line 1854: per_all_people_f pp_c

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
1858: and pcr.person_id = pa.person_id

Line 1892: per_all_people_f pp_c

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
1896: and pcr.person_id = pa.person_id

Line 1934: per_all_people_f pp_c

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
1938: and pcr.person_id = pa.person_id

Line 1958: per_all_people_f pp_c

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
1962: and pcr.person_id = pa.person_id

Line 2307: per_all_people_f pp_c

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
2311: and pcr.person_id = pa.person_id

Line 2354: per_all_people_f pp_c

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
2358: and pcr.person_id = pa.person_id