APPS.PER_BULK_APP_ASG_CHANGE_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 391: delete from per_letter_request_lines l

387: p_assignment_status_type_id in number,
388: p_business_group_id in number) is
389: begin
390: --
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

Line 409: from per_letter_request_lines l

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
409: from per_letter_request_lines l
410: where l.letter_request_id = r.letter_request_id
411: ) ;
412: message('DELETED '||to_char(sql%rowcount)||' ROWS FROM LETTER REQUESTS');
413: --