APPS.HR_ASSIGNMENT_API dependencies on PER_LETTER_REQUEST_LINES

Line 17878: delete from per_letter_request_lines plrl

17874: --
17875: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
17876: nvl(p_vacancy_id,-1) <> hr_api.g_number ) THEN
17877: --
17878: delete from per_letter_request_lines plrl
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

Line 17900: from per_letter_request_lines plrl

17896: and plr.request_status = 'PENDING'
17897: and plr.auto_or_manual = 'AUTO'
17898: and not exists
17899: ( select 1
17900: from per_letter_request_lines plrl
17901: where plrl.letter_request_id = plr.letter_request_id
17902: ) ;
17903: --
17904: per_applicant_pkg.check_for_letter_requests

Line 21621: delete from per_letter_request_lines plrl

21617: ,p_legislation_code => l_assignment.legislation_code
21618: ,p_expected_system_status => 'TERM_APL'
21619: );
21620: --fix for bug 7229710 Start here.
21621: delete from per_letter_request_lines plrl
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