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_QH_ACTION dependencies on PER_LETTER_REQUEST_LINES

Line 209: update per_letter_request_lines

205: and date_received=l_hire_date;
206: --
207: -- move associated letter requests
208: --
209: update per_letter_request_lines
210: set date_from=l_hire_date-1
211: where assignment_id=(select asg2.assignment_id
212: from per_all_assignments_f asg2
213: where asg2.person_id=p_person_id

Line 375: update per_letter_request_lines

371: --
372: --
373: -- move associated letter requests
374: --
375: update per_letter_request_lines
376: set date_from=l_hire_date-1
377: where assignment_id=(select asg2.assignment_id
378: from per_all_assignments_f asg2
379: where asg2.person_id=p_person_id

Line 409: update per_letter_request_lines

405: -- recent end date back one day
406: --
407: -- move associated letter requests
408: --
409: update per_letter_request_lines
410: set date_from=l_hire_date-1
411: where assignment_id=(select asg2.assignment_id
412: from per_all_assignments_f asg2
413: where asg2.person_id=p_person_id