1688: delete from per_events par
1689: where par.assignment_id = p_assignment_id;
1690: --
1691: -- - per_pay_proposals
1692: -- - per_pay_proposal_components
1693: --
1694: delete from per_pay_proposal_components chd
1695: where chd.pay_proposal_id in
1696: (select par.pay_proposal_id
1690: --
1691: -- - per_pay_proposals
1692: -- - per_pay_proposal_components
1693: --
1694: delete from per_pay_proposal_components chd
1695: where chd.pay_proposal_id in
1696: (select par.pay_proposal_id
1697: from per_pay_proposals par
1698: where par.assignment_id = p_assignment_id