APPS.HR_ASSIGNMENT_API dependencies on PER_LETTER_REQUEST_LINES

Line 18741: delete from per_letter_request_lines plrl

18737: --
18738: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
18739: nvl(p_vacancy_id,-1) <> hr_api.g_number ) THEN
18740: --
18741: delete from per_letter_request_lines plrl
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

Line 18763: from per_letter_request_lines plrl

18759: and plr.request_status = 'PENDING'
18760: and plr.auto_or_manual = 'AUTO'
18761: and not exists
18762: ( select 1
18763: from per_letter_request_lines plrl
18764: where plrl.letter_request_id = plr.letter_request_id
18765: ) ;
18766: --
18767: per_applicant_pkg.check_for_letter_requests

Line 22549: delete from per_letter_request_lines plrl

22545: ,p_legislation_code => l_assignment.legislation_code
22546: ,p_expected_system_status => 'TERM_APL'
22547: );
22548: --fix for bug 7229710 Start here.
22549: delete from per_letter_request_lines plrl
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