APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_ALL_PEOPLE_F

Line 1517: per_all_people_f pp

1513: 'N',to_char(least(nvl(ppos.final_process_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
1514: to_char(nvl(ppos.final_process_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date_proc
1515: from per_all_assignments_f pa,
1516: per_periods_of_service ppos,
1517: per_all_people_f pp
1518: where pa.assignment_id = p_assignment_id
1519: and ppos.period_of_service_id = pa.period_of_service_id
1520: and to_date(decode(nvl(g_inc_term_flag,'N'),
1521: 'N',to_char(least(nvl(ppos.actual_termination_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),

Line 1893: per_all_people_f pp

1889: fnd_number.canonical_to_number(pcr.cont_information2) sequence,
1890: pcr.cont_information3 household_head,
1891: pcr.cont_information1 si_itax
1892: from per_contact_relationships pcr,
1893: per_all_people_f pp
1894: where pcr.person_id = l_person_id
1895: and l_effective_date_ass
1896: between nvl(pcr.date_start,hr_api.g_sot) and nvl(pcr.date_end,l_effective_date_ass)
1897: and pp.person_id = pcr.contact_person_id

Line 1903: from per_all_people_f pp2

1899: between pp.effective_start_date and pp.effective_end_date
1900: or (pp.effective_start_date = pp.start_date
1901: and not exists(
1902: select null
1903: from per_all_people_f pp2
1904: where pp2.person_id = pp.person_id
1905: and l_effective_date_ass
1906: between pp2.effective_start_date and pp2.effective_end_date)))
1907: order by