APPS.PER_APP_ASG_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 89: delete from per_letter_request_lines p

85: -- As below
86: procedure cleanup_letters ( p_assignment_id in number ) is
87: begin
88: --
89: delete from per_letter_request_lines p
90: where p.assignment_id = p_assignment_id
91: and exists
92: (select null
93: from per_letter_requests r2

Line 1355: delete from per_letter_request_lines plrl

1351: THEN
1352: --
1353: IF nvl(l_previous_vacancy_id,-1) <> nvl(p_vacancy_id,-1) THEN
1354: --
1355: delete from per_letter_request_lines plrl
1356: where plrl.assignment_id = p_assignment_id
1357: and plrl.assignment_status_type_id = p_assignment_status_type_id
1358: and exists
1359: (select null

Line 1376: from per_letter_request_lines plrl

1372: and plr.request_status = 'PENDING'
1373: and plr.auto_or_manual = 'AUTO'
1374: and not exists
1375: ( select 1
1376: from per_letter_request_lines plrl
1377: where plrl.letter_request_id = plr.letter_request_id
1378: ) ;
1379: --
1380: per_applicant_pkg.check_for_letter_requests