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.HXC_FIND_NOTIFY_APRS_PKG dependencies on PER_PEOPLE_F

Line 151: select p.full_name from per_people_f p

147: p_effective_date in DATE)
148: return varchar2
149: is
150: cursor csr_name(b_person_id NUMBER, b_effective_date DATE) is
151: select p.full_name from per_people_f p
152: where p.person_id=b_person_id
153: and b_effective_date between p.effective_start_date and p.effective_end_date;
154:
155: cursor csr_closest_name1

Line 1990: --Changed for 115.60; used per_all_people_f instead of per_people_f

1986: raise;
1987: end person_approval;
1988:
1989: --Function to check if a given approver is terminated (Bug#3160848)
1990: --Changed for 115.60; used per_all_people_f instead of per_people_f
1991: FUNCTION validate_person(
1992: p_person_id in number,
1993: p_effective_date in date)
1994: RETURN BOOLEAN