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 1989: l_full_name per_all_people_f.full_name%TYPE;

1985: FROM per_people_f
1986: WHERE person_id = p_person_id
1987: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1988:
1989: l_full_name per_all_people_f.full_name%TYPE;
1990: l_procedure CONSTANT VARCHAR2(100):= g_package ||'get_person_name';
1991:
1992: BEGIN
1993: set_location(g_debug,'Entering : '||l_procedure,10);

Line 2471: per_all_people_f ppf,

2467: CURSOR c_relationship
2468: IS
2469: SELECT hr_general.decode_lookup('CONTACT',RELATION.CONTACT_TYPE)
2470: FROM per_contact_relationships relation,
2471: per_all_people_f ppf,
2472: per_all_assignments_f asg
2473: WHERE relation.contact_person_id = p_contact_person_id
2474: AND relation.person_id = ppf.person_id
2475: AND asg.person_id = ppf.person_id