APPS.PER_APP_ASG_PKG dependencies on PER_LETTER_REQUESTS

Line 98: from per_letter_requests r2

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
99: where r2.letter_request_id = p.letter_request_id
100: and r2.request_status = 'PENDING')
101: and not exists
102: (select null

Line 1542: from per_letter_requests plr

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
1542: from per_letter_requests plr
1543: where plr.letter_request_id = plrl.letter_request_id
1544: and plr.request_status = 'PENDING'
1545: and plr.auto_or_manual = 'AUTO');
1546: --

Line 1553: delete from per_letter_requests plr

1549: cleanup_letters( p_assignment_id => p_assignment_id);
1550: --
1551: --Performance Fix done by removing +0
1552: hr_utility.set_location ('per_app_asg_pkg.update_row', 18);
1553: delete from per_letter_requests plr
1554: where plr.business_group_id = p_business_group_id
1555: and plr.request_status = 'PENDING'
1556: and plr.auto_or_manual = 'AUTO'
1557: and not exists