DBA Data[Home] [Help]

APPS.PQP_PRORATION_WRAPPER dependencies on PAY_FUNCTIONAL_USAGES

Line 148: FROM pay_functional_usages

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 ||

Line 287: -- The following code inserts a row in pay_functional_usages table for the

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));

Line 292: pay_functional_usages_pkg.insert_row(

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 ,