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.

[Home] [Help]

APPS.PER_QH_ACTION dependencies on PER_LETTER_REQUEST_LINES

Line 234: update per_letter_request_lines

230: and date_received=l_hire_date;
231: --
232: -- move associated letter requests
233: --
234: update per_letter_request_lines
235: set date_from=l_hire_date-1
236: where assignment_id=(select asg2.assignment_id
237: from per_all_assignments_f asg2
238: where asg2.person_id=p_person_id

Line 400: update per_letter_request_lines

396: --
397: --
398: -- move associated letter requests
399: --
400: update per_letter_request_lines
401: set date_from=l_hire_date-1
402: where assignment_id=(select asg2.assignment_id
403: from per_all_assignments_f asg2
404: where asg2.person_id=p_person_id

Line 434: update per_letter_request_lines

430: -- recent end date back one day
431: --
432: -- move associated letter requests
433: --
434: update per_letter_request_lines
435: set date_from=l_hire_date-1
436: where assignment_id=(select asg2.assignment_id
437: from per_all_assignments_f asg2
438: where asg2.person_id=p_person_id