[Home] [Help]
574: --
575: -- Remove the pay proposal if there are no element entries for it.
576: --
577: -- bug 9648525 remove proposal components as well as proposal
578: delete from per_pay_proposal_components ppc
579: where ppc.pay_proposal_id in ( select pp.pay_proposal_id
580: from per_pay_proposals pp
581: where pp.assignment_id = p_assignment_id
582: and pp.pay_proposal_id = p_pay_proposal_id