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.PA_RESOURCE_PVT dependencies on PER_ADDRESSES

Line 1029: FROM per_addresses

1025:
1026: CURSOR denormalized_locations (l_person_id IN NUMBER, l_asgn_start_date IN DATE, l_asgn_end_date IN DATE ) IS
1027: SELECT date_from,
1028: date_to
1029: FROM per_addresses
1030: WHERE person_id = l_person_id
1031: AND date_from <= l_asgn_end_date
1032: AND nvl(date_to, l_asgn_end_date) >= l_asgn_start_date
1033: AND primary_flag = 'Y'