[Home] [Help]
1318: --
1319: cursor chk_county_tax_rules
1320: is
1321: select null
1322: from pay_us_emp_county_tax_rules_f cnt
1323: where cnt.assignment_id = p_assignment_id
1324: and cnt.state_code = pay_sta_shd.g_old_rec.state_code
1325: and cnt.effective_end_date > p_effective_date;
1326: --
1437: if chk_county_tax_rules%found then
1438: close chk_county_tax_rules;
1439: hr_utility.set_message(801,'HR_7215_DT_CHILD_EXISTS');
1440: hr_utility.set_message_token('TABLE_NAME',
1441: 'PAY_US_EMP_COUNTY_TAX_RULES_F');
1442: hr_utility.raise_error;
1443: end if;
1444: close chk_county_tax_rules;
1445: --