DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 1649: DELETE FROM pay_org_pay_method_usages_f pmu

1645: open csr_get_bg_payrolls(p_business_group_id);
1646: fetch csr_get_bg_payrolls into l_exists;
1647: if csr_get_bg_payrolls%found then
1648: --
1649: DELETE FROM pay_org_pay_method_usages_f pmu
1650: WHERE
1651: EXISTS ( SELECT ''
1652: FROM pay_payrolls_f pp
1653: WHERE pp.payroll_id = pmu.payroll_id