APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 422: from per_letter_request_lines p

418: -- letters cursor
419: --
420: cursor letters is
421: select p.rowid
422: from per_letter_request_lines p
423: , per_assignments_f paf
424: where p.assignment_id = paf.assignment_id
425: and paf.business_group_id + 0 = p_business_group_id
426: and paf.person_id = p_person_id

Line 2175: from per_letter_request_lines p

2171: -- letters cursor
2172: --
2173: cursor letters2(p_assignment_id NUMBER) is
2174: select p.letter_request_line_id
2175: from per_letter_request_lines p
2176: where p.assignment_id = p_assignment_id;
2177: --
2178: -- Comments cursor
2179: --

Line 2417: delete from per_letter_request_lines plrl

2413: <>
2414: loop
2415: fetch letters2 into l_pk_id;
2416: exit when letters2%NOTFOUND;
2417: delete from per_letter_request_lines plrl
2418: where plrl.letter_request_line_id = l_pk_id;
2419: if sql%notfound then
2420: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2421: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');