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.HR_APPLICANT_API dependencies on PER_LETTER_REQUESTS

Line 3516: from per_letter_requests plr

3512: where plrl.assignment_id = l_assignment.assignment_id
3513: and plrl.assignment_status_type_id = l_assignment.assignment_status_type_id
3514: and exists
3515: (select null
3516: from per_letter_requests plr
3517: where plr.letter_request_id = plrl.letter_request_id
3518: and plr.request_status = 'PENDING'
3519: and plr.auto_or_manual = 'AUTO');
3520: