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 18746: from per_letter_requests plr

18742: where plrl.assignment_id = p_assignment_id
18743: and plrl.assignment_status_type_id = p_assignment_status_type_id
18744: and exists
18745: (select null
18746: from per_letter_requests plr
18747: where plr.letter_request_id = plrl.letter_request_id
18748: and plr.request_status = 'PENDING'
18749: and plr.auto_or_manual = 'AUTO');
18750: --

Line 18757: delete from per_letter_requests plr

18753: per_app_asg_pkg.cleanup_letters
18754: ( p_assignment_id => p_assignment_id);
18755: --
18756: --
18757: delete from per_letter_requests plr
18758: where plr.business_group_id = l_business_group_id
18759: and plr.request_status = 'PENDING'
18760: and plr.auto_or_manual = 'AUTO'
18761: and not exists

Line 22554: from per_letter_requests plr

22550: where plrl.assignment_id = p_assignment_id
22551: and plrl.assignment_status_type_id = l_assignment.assignment_status_type_id
22552: and exists
22553: (select null
22554: from per_letter_requests plr
22555: where plr.letter_request_id = plrl.letter_request_id
22556: and plr.request_status = 'PENDING'
22557: and plr.auto_or_manual = 'AUTO');
22558: