APPS.PER_APP_ASG_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 94: delete from per_letter_request_lines p

90: begin
91: --
92: hr_utility.set_location ( 'PER_APP_ASG_PKG.cleanup_letters' , 5) ;
93: --
94: delete from per_letter_request_lines p
95: where p.assignment_id = p_assignment_id
96: and exists
97: (select null
98: from per_letter_requests r2

Line 1537: delete from per_letter_request_lines plrl

1533: THEN
1534: --
1535: IF nvl(l_previous_vacancy_id,-1) <> nvl(p_vacancy_id,-1) THEN
1536: --
1537: delete from per_letter_request_lines plrl
1538: where plrl.assignment_id = p_assignment_id
1539: and plrl.assignment_status_type_id = p_assignment_status_type_id
1540: and exists
1541: (select null

Line 1559: from per_letter_request_lines plrl

1555: and plr.request_status = 'PENDING'
1556: and plr.auto_or_manual = 'AUTO'
1557: and not exists
1558: ( select 1
1559: from per_letter_request_lines plrl
1560: where plrl.letter_request_id = plr.letter_request_id
1561: ) ;
1562: --
1563: hr_utility.set_location ('per_app_asg_pkg.update_row', 19);