APPS.PER_APP_ASG_PKG dependencies on PER_LETTER_REQUESTS

Line 93: from per_letter_requests r2

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
94: where r2.letter_request_id = p.letter_request_id
95: and r2.request_status = 'PENDING')
96: and not exists
97: (select null

Line 1360: from per_letter_requests plr

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
1360: from per_letter_requests plr
1361: where plr.letter_request_id = plrl.letter_request_id
1362: and plr.request_status = 'PENDING'
1363: and plr.auto_or_manual = 'AUTO');
1364: --

Line 1370: delete from per_letter_requests plr

1366: --
1367: cleanup_letters( p_assignment_id => p_assignment_id);
1368: --
1369: --Performance Fix done by removing +0
1370: delete from per_letter_requests plr
1371: where plr.business_group_id = p_business_group_id
1372: and plr.request_status = 'PENDING'
1373: and plr.auto_or_manual = 'AUTO'
1374: and not exists