APPS.HR_PERSON_DELETE dependencies on PER_LETTER_REQUEST_LINES

Line 694: from per_letter_request_lines r

690: into v_delete_permitted
691: from sys.dual
692: where not exists (
693: select null
694: from per_letter_request_lines r
695: where r.person_id = P_PERSON_ID
696: and r.date_from >= P_SESSION_DATE );
697:
698: select 'Y'

Line 703: from per_letter_request_lines r

699: into v_delete_permitted
700: from sys.dual
701: where not exists (
702: select null
703: from per_letter_request_lines r
704: where exists (
705: select null
706: from per_assignments_f a
707: where a.person_id = P_PERSON_ID

Line 717: from per_letter_request_lines r

713: into v_delete_permitted
714: from sys.dual
715: where not exists (
716: select null
717: from per_letter_request_lines r
718: where r.person_id = P_PERSON_ID
719: and r.date_from >= P_SESSION_DATE
720: or exists (
721: select null

Line 1536: delete from per_letter_request_lines l

1532: begin
1533: -- bug fix 3732129.
1534: -- Delete statement modified to improve performance.
1535:
1536: delete from per_letter_request_lines l
1537: where l.person_id = P_PERSON_ID;
1538:
1539: forall i in 1..l_assignment_id.count
1540: delete from per_letter_request_lines l

Line 1540: delete from per_letter_request_lines l

1536: delete from per_letter_request_lines l
1537: where l.person_id = P_PERSON_ID;
1538:
1539: forall i in 1..l_assignment_id.count
1540: delete from per_letter_request_lines l
1541: where l.assignment_id = l_assignment_id(i);
1542:
1543: /*
1544: delete from per_letter_request_lines l

Line 1544: delete from per_letter_request_lines l

1540: delete from per_letter_request_lines l
1541: where l.assignment_id = l_assignment_id(i);
1542:
1543: /*
1544: delete from per_letter_request_lines l
1545: where l.person_id = P_PERSON_ID
1546: or exists (
1547: select null
1548: from per_assignments_f a