APPS.PER_BULK_APP_ASG_CHANGE_PKG dependencies on PER_LETTER_REQUESTS

Line 395: from per_letter_requests r

391: delete from per_letter_request_lines l
392: where l.assignment_id = p_assignment_id
393: and l.assignment_status_type_id <> p_assignment_status_type_id
394: and exists ( select 1
395: from per_letter_requests r
396: where r.letter_request_id = l.letter_request_id
397: and r.request_status = 'PENDING'
398: and r.auto_or_manual = 'AUTO' ) ;
399: message('DELETED '||to_char(sql%rowcount)||' ROWS FROM REQUEST LINES');

Line 404: delete from per_letter_requests r

400: --
401: --
402: -- Remove any 'empty' requests in the current business group
403: --
404: delete from per_letter_requests r
405: where r.business_group_id = p_business_group_id
406: and r.request_status = 'PENDING'
407: and r.auto_or_manual = 'AUTO'
408: and not exists ( select 1