APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ASSIGN_PROPOSAL_ANSWERS

Line 2265: from per_assign_proposal_answers papa

2261: -- asg proposal answers cursor
2262: --
2263: cursor asg_prop_answer2(p_assignment_id NUMBER) is
2264: select papa.rowid
2265: from per_assign_proposal_answers papa
2266: where p_assignment_id = papa.assignment_id;
2267: --
2268: -- disabilities cursor
2269: --

Line 2484: delete from per_assign_proposal_answers papa

2480: <>
2481: loop
2482: fetch asg_prop_answer2 into l_rowid;
2483: exit when asg_prop_answer2%NOTFOUND;
2484: delete from per_assign_proposal_answers papa
2485: where papa.rowid = l_rowid;
2486: if sql%notfound then
2487: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2488: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');