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_ASSIGNMENT_API dependencies on PER_LETTER_REQUESTS

Line 17883: from per_letter_requests plr

17879: where plrl.assignment_id = p_assignment_id
17880: and plrl.assignment_status_type_id = p_assignment_status_type_id
17881: and exists
17882: (select null
17883: from per_letter_requests plr
17884: where plr.letter_request_id = plrl.letter_request_id
17885: and plr.request_status = 'PENDING'
17886: and plr.auto_or_manual = 'AUTO');
17887: --

Line 17894: delete from per_letter_requests plr

17890: per_app_asg_pkg.cleanup_letters
17891: ( p_assignment_id => p_assignment_id);
17892: --
17893: --
17894: delete from per_letter_requests plr
17895: where plr.business_group_id = l_business_group_id
17896: and plr.request_status = 'PENDING'
17897: and plr.auto_or_manual = 'AUTO'
17898: and not exists

Line 21626: from per_letter_requests plr

21622: where plrl.assignment_id = p_assignment_id
21623: and plrl.assignment_status_type_id = l_assignment.assignment_status_type_id
21624: and exists
21625: (select null
21626: from per_letter_requests plr
21627: where plr.letter_request_id = plrl.letter_request_id
21628: and plr.request_status = 'PENDING'
21629: and plr.auto_or_manual = 'AUTO');
21630: