DBA Data[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