DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 124: per_pay_proposal_components and

120: pay_ele_freq_rules and
121: ben_benefit_contributions_f.
122: 70.33 22-JAN-96 mhoyes Added delete statements to
123: delete_assign_detail which delete from
124: per_pay_proposal_components and
125: per_pay_proposals for a business group.
126: 70.34 19-MAR-95 dsaxby Now call py_rollback_pkg version of
127: rollback_payroll_action.
128: 70.35 28-JUN-96 mhoyes a Added delete statement to

Line 849: delete from per_pay_proposal_components ppc

845: open csr_get_pyp (p_business_group_id);
846: fetch csr_get_pyp into l_exists;
847: if csr_get_pyp%found then
848: --
849: delete from per_pay_proposal_components ppc
850: where ppc.business_group_id = p_business_group_id;
851: hr_utility.set_location(l_proc, 70);
852: --
853: delete from per_pay_proposals