APPS.HR_PERSON_INTERNAL dependencies on PER_LETTER_REQUEST_LINES

Line 862: from per_letter_request_lines r

858: into l_delete_permitted
859: from sys.dual
860: where not exists (
861: select null
862: from per_letter_request_lines r
863: where r.person_id = P_PERSON_ID
864: and r.date_from >= p_effective_date );
865: --
866: select 'Y'

Line 871: from per_letter_request_lines r

867: into l_delete_permitted
868: from sys.dual
869: where not exists (
870: select null
871: from per_letter_request_lines r
872: where exists (
873: select null
874: from per_assignments_f a
875: where a.person_id = P_PERSON_ID

Line 2132: delete from per_letter_request_lines l

2128: --
2129: begin
2130: -- bug fix 3732129.
2131: -- Delete statement modified to improve performance.
2132: delete from per_letter_request_lines l
2133: where l.person_id = P_PERSON_ID;
2134: --
2135: forall i in 1..l_assignment_id.count
2136: delete from per_letter_request_lines l

Line 2136: delete from per_letter_request_lines l

2132: delete from per_letter_request_lines l
2133: where l.person_id = P_PERSON_ID;
2134: --
2135: forall i in 1..l_assignment_id.count
2136: delete from per_letter_request_lines l
2137: where l.assignment_id = l_assignment_id(i);
2138: --
2139: exception
2140: when NO_DATA_FOUND then