APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ASSIGN_PROPOSAL_ANSWERS

Line 3265: from per_assign_proposal_answers papa

3261: -- asg proposal answers cursor
3262: --
3263: cursor asg_prop_answer2(p_assignment_id NUMBER) is
3264: select papa.rowid
3265: from per_assign_proposal_answers papa
3266: where p_assignment_id = papa.assignment_id;
3267: --
3268: -- disabilities cursor
3269: --

Line 3548: delete from per_assign_proposal_answers papa

3544: <>
3545: loop
3546: fetch asg_prop_answer2 into l_rowid;
3547: exit when asg_prop_answer2%NOTFOUND;
3548: delete from per_assign_proposal_answers papa
3549: where papa.rowid = l_rowid;
3550: if sql%notfound then
3551: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3552: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');