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

Line 1409: ,per_addresses pad

1405: ,pad.add_information14 info14
1406: ,pad.add_information15 info15
1407: ,pad.add_information16 info16
1408: FROM per_all_assignments_f pas
1409: ,per_addresses pad
1410: WHERE pas.assignment_id = p_assignment_id
1411: AND p_start_date BETWEEN pas.effective_start_date
1412: AND pas.effective_end_date
1413: AND pas.person_id = pad.person_id

Line 1419: FROM per_addresses pad1

1415: AND pad.address_type = 'NL_SICK'
1416: AND pad.date_from =
1417: (
1418: SELECT max (pad1.date_from)
1419: FROM per_addresses pad1
1420: WHERE pad1.person_id = pad.person_id
1421: AND (
1422: p_start_date BETWEEN pad1.date_from
1423: AND nvl (pad1.date_to

Line 1449: ,per_addresses pad

1445: ,pad.add_information14 info14
1446: ,pad.add_information15 info15
1447: ,pad.add_information16 info16
1448: FROM per_all_assignments_f pas
1449: ,per_addresses pad
1450: WHERE pas.assignment_id = p_assignment_id
1451: AND p_start_date BETWEEN pas.effective_start_date
1452: AND pas.effective_end_date
1453: AND pad.person_id = pas.person_id