APPS.PSP_GENERAL dependencies on PER_PEOPLE_F

Line 1848: from per_people_f ppf

1844:
1845: FUNCTION get_person_name_er(p_person_id IN VARCHAR2, p_effective_date IN DATE) RETURN VARCHAR2 IS
1846: cursor eff_dates is
1847: select max(ppf.effective_end_date),min(ppf.effective_start_date)
1848: from per_people_f ppf
1849: where ppf.current_employee_flag = 'Y'
1850: and ppf.person_id = p_person_id
1851: group by ppf.person_id ;
1852:

Line 1855: select full_name from per_people_f

1851: group by ppf.person_id ;
1852:
1853: cursor c1(p_calculated_date date)
1854: is
1855: select full_name from per_people_f
1856: where person_id = p_person_id
1857: and p_calculated_date between effective_start_date and effective_end_date;
1858:
1859: l_person_name varchar2(240);

Line 1909: from per_people_f ppf

1905: IS
1906:
1907: cursor eff_dates is
1908: select max(ppf.effective_end_date),min(ppf.effective_start_date)
1909: from per_people_f ppf
1910: where ppf.current_employee_flag = 'Y'
1911: and ppf.person_id = p_person_id
1912: group by ppf.person_id ;
1913: