1660: delete from per_events par
1661: where par.assignment_id = p_assignment_id;
1662: --
1663: -- - per_pay_proposals
1664: -- - per_pay_proposal_components
1665: --
1666: delete from per_pay_proposal_components chd
1667: where chd.pay_proposal_id in
1668: (select par.pay_proposal_id
1662: --
1663: -- - per_pay_proposals
1664: -- - per_pay_proposal_components
1665: --
1666: delete from per_pay_proposal_components chd
1667: where chd.pay_proposal_id in
1668: (select par.pay_proposal_id
1669: from per_pay_proposals par
1670: where par.assignment_id = p_assignment_id