DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 578: delete from per_pay_proposal_components ppc

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