APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PER_ALL_PEOPLE_F

Line 1890: from per_all_people_f pp

1886: l_exists VARCHAR2(1);
1887:
1888: cursor c1 is
1889: select 'x'
1890: from per_all_people_f pp
1891: where nvl(p_date_start,nvl(p_proj_start,p_sess)) >=
1892: (select min(ppf.effective_start_date)
1893: from per_all_people_f ppf
1894: where pp.person_id = ppf.person_id

Line 1893: from per_all_people_f ppf

1889: select 'x'
1890: from per_all_people_f pp
1891: where nvl(p_date_start,nvl(p_proj_start,p_sess)) >=
1892: (select min(ppf.effective_start_date)
1893: from per_all_people_f ppf
1894: where pp.person_id = ppf.person_id
1895: and pp.current_employee_flag = ppf.current_employee_flag)
1896: and nvl(p_date_end,nvl(p_proj_end,p_sess)) <=
1897: (select max(ppf.effective_end_date)

Line 1898: from per_all_people_f ppf

1894: where pp.person_id = ppf.person_id
1895: and pp.current_employee_flag = ppf.current_employee_flag)
1896: and nvl(p_date_end,nvl(p_proj_end,p_sess)) <=
1897: (select max(ppf.effective_end_date)
1898: from per_all_people_f ppf
1899: where pp.person_id = ppf.person_id
1900: and pp.current_employee_flag = ppf.current_employee_flag)
1901: -- where nvl(p_date_start,nvl(p_proj_start,p_sess)) between
1902: -- pp.effective_start_date and pp.effective_end_date

Line 1936: from per_all_people_f pp

1932: l_exists VARCHAR2(1);
1933:
1934: cursor c3 is
1935: select 'x'
1936: from per_all_people_f pp
1937: where nvl(p_date_start,nvl(p_date_proj_start,p_sess)) >=
1938: (select min(ppf.effective_start_date)
1939: from per_all_people_f ppf
1940: where pp.person_id = ppf.person_id

Line 1939: from per_all_people_f ppf

1935: select 'x'
1936: from per_all_people_f pp
1937: where nvl(p_date_start,nvl(p_date_proj_start,p_sess)) >=
1938: (select min(ppf.effective_start_date)
1939: from per_all_people_f ppf
1940: where pp.person_id = ppf.person_id
1941: and pp.current_employee_flag = ppf.current_employee_flag)
1942: and nvl(p_date_end,nvl(p_date_proj_end,p_sess)) <=
1943: (select max(ppf.effective_end_date)

Line 1944: from per_all_people_f ppf

1940: where pp.person_id = ppf.person_id
1941: and pp.current_employee_flag = ppf.current_employee_flag)
1942: and nvl(p_date_end,nvl(p_date_proj_end,p_sess)) <=
1943: (select max(ppf.effective_end_date)
1944: from per_all_people_f ppf
1945: where pp.person_id = ppf.person_id
1946: and pp.current_employee_flag = ppf.current_employee_flag)
1947: -- where nvl(p_date_start,nvl(p_date_proj_start,p_sess)) between
1948: -- pp.effective_start_date and pp.effective_end_date