144:
145: CURSOR c_functional_usages(p_area_id IN NUMBER ,
146: p_business_group_Id IN NUMBER ) IS
147: SELECT COUNT(*) count
148: FROM pay_functional_usages
149: WHERE area_id = p_area_id
150: AND business_group_id = p_business_group_id;
151: BEGIN
152: hr_utility.set_location('Entering {' || gv_package ||
283: l_count := c2.count;
284: END LOOP;
285:
286: --************************************************************************
287: -- The following code inserts a row in pay_functional_usages table for the
288: -- respective Business Group.
289: --************************************************************************
290: IF (l_count = 0) THEN
291: hr_utility.trace('The count is ' || TO_CHAR(l_count));
288: -- respective Business Group.
289: --************************************************************************
290: IF (l_count = 0) THEN
291: hr_utility.trace('The count is ' || TO_CHAR(l_count));
292: pay_functional_usages_pkg.insert_row(
293: p_row_id => l_row_id ,
294: p_usage_id => l_usage_id ,
295: p_area_id => l_area_id ,
296: p_legislation_code => NULL ,