APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 590: from per_letter_request_lines p

586: -- letters cursor
587: --
588: cursor letters is
589: select p.rowid
590: from per_letter_request_lines p
591: , per_assignments_f paf
592: where p.assignment_id = paf.assignment_id
593: and paf.business_group_id + 0 = p_business_group_id
594: and paf.person_id = p_person_id

Line 3175: from per_letter_request_lines p

3171: -- letters cursor
3172: --
3173: cursor letters2(p_assignment_id NUMBER) is
3174: select p.letter_request_line_id
3175: from per_letter_request_lines p
3176: where p.assignment_id = p_assignment_id;
3177: --
3178: -- Comments cursor
3179: --

Line 3481: delete from per_letter_request_lines plrl

3477: <>
3478: loop
3479: fetch letters2 into l_pk_id;
3480: exit when letters2%NOTFOUND;
3481: delete from per_letter_request_lines plrl
3482: where plrl.letter_request_line_id = l_pk_id;
3483: if sql%notfound then
3484: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3485: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');