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.PAY_IN_UTILS dependencies on PER_ALL_PEOPLE_F

Line 2004: l_full_name per_all_people_f.full_name%TYPE;

2000: FROM per_people_f
2001: WHERE person_id = p_person_id
2002: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2003:
2004: l_full_name per_all_people_f.full_name%TYPE;
2005: l_procedure CONSTANT VARCHAR2(100):= g_package ||'get_person_name';
2006:
2007: BEGIN
2008: set_location(g_debug,'Entering : '||l_procedure,10);

Line 2486: per_all_people_f ppf,

2482: CURSOR c_relationship
2483: IS
2484: SELECT hr_general.decode_lookup('CONTACT',RELATION.CONTACT_TYPE)
2485: FROM per_contact_relationships relation,
2486: per_all_people_f ppf,
2487: per_all_assignments_f asg
2488: WHERE relation.contact_person_id = p_contact_person_id
2489: AND relation.person_id = ppf.person_id
2490: AND asg.person_id = ppf.person_id