DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 6672: delete from per_pay_proposal_components ppc

6668: fetch csr_accepted_pay_proposals into v_pay_proposal_id;
6669: exit when csr_accepted_pay_proposals%notfound;
6670:
6671: --- bug 9648525 remove proposal components as well as proposal
6672: delete from per_pay_proposal_components ppc
6673: where ppc.pay_proposal_id in
6674: ( select pp.pay_proposal_id from per_pay_proposals pp
6675: where pp.pay_proposal_id = v_pay_proposal_id
6676: and not exists

Line 8864: delete from per_pay_proposal_components ppc

8860: fetch csr_accepted_pay_proposals into v_pay_proposal_id;
8861: exit when csr_accepted_pay_proposals%notfound;
8862: --
8863: -- bug 9648525 remove proposal components as well as proposal
8864: delete from per_pay_proposal_components ppc
8865: where ppc.pay_proposal_id in
8866: ( select pp.pay_proposal_id from per_pay_proposals pp
8867: where pp.pay_proposal_id = v_pay_proposal_id
8868: and not exists