DBA Data[Home] [Help]

APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 34: delete from per_pay_proposal_components ppc

30: open ppr1(p_assignment_id);
31: fetch ppr1 into p_pay_proposal_id;
32: loop
33: exit when ppr1%notfound;
34: delete from per_pay_proposal_components ppc
35: where ppc.pay_proposal_id = p_pay_proposal_id;
36: fetch ppr1 into p_pay_proposal_id;
37: end loop;
38: close ppr1;