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_DSR_ARCHIVE dependencies on PER_ADDRESSES

Line 1608: ,per_addresses pad

1604: ,pad.add_information14 info14
1605: ,pad.add_information15 info15
1606: ,pad.add_information16 info16
1607: FROM per_all_assignments_f pas
1608: ,per_addresses pad
1609: WHERE pas.assignment_id = p_assignment_id
1610: AND p_start_date BETWEEN pas.effective_start_date
1611: AND pas.effective_end_date
1612: AND pas.person_id = pad.person_id

Line 1618: FROM per_addresses pad1

1614: AND pad.address_type = 'NL_SICK'
1615: AND pad.date_from =
1616: (
1617: SELECT max (pad1.date_from)
1618: FROM per_addresses pad1
1619: WHERE pad1.person_id = pad.person_id
1620: AND (
1621: p_start_date BETWEEN pad1.date_from
1622: AND nvl (pad1.date_to

Line 1648: ,per_addresses pad

1644: ,pad.add_information14 info14
1645: ,pad.add_information15 info15
1646: ,pad.add_information16 info16
1647: FROM per_all_assignments_f pas
1648: ,per_addresses pad
1649: WHERE pas.assignment_id = p_assignment_id
1650: AND p_start_date BETWEEN pas.effective_start_date
1651: AND pas.effective_end_date
1652: AND pad.person_id = pas.person_id