APPS.HR_DELETE dependencies on PAY_DEFINED_BALANCES

Line 1707: FROM PAY_DEFINED_BALANCES

1703: cursor csr_get_def_bals
1704: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)
1705: is
1706: SELECT null
1707: FROM PAY_DEFINED_BALANCES
1708: WHERE business_group_id = c_business_group_id;
1709: --
1710: cursor csr_get_bal_types
1711: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)

Line 1752: DELETE FROM pay_defined_balances pdb

1748: open csr_get_def_bals(p_business_group_id);
1749: fetch csr_get_def_bals into l_exists;
1750: if csr_get_def_bals%found then
1751: --
1752: DELETE FROM pay_defined_balances pdb
1753: WHERE pdb.business_group_id = p_business_group_id;
1754: hr_utility.set_location(l_proc,80);
1755: --
1756: end if;