DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PER_DEFAULT_BUDGET_VALUES

Line 2314: is because the view per_default_budget_values is in fact returning

2310: hr_utility.set_location('hr_assignment.load_budget_values',1);
2311: --
2312: /* 25/05/95 Fixed bug 273820 - performance of following statement
2313: NB the business_group_id no longer needs +0 appended to it, this
2314: is because the view per_default_budget_values is in fact returning
2315: organization_id in place of business_group_id in ordre to make use
2316: of an index
2317: */
2318: -- Change to include effective start and end dates in parameters and logic to check these and

Line 2350: from per_default_budget_values pabv1

2346: , pabv1.unit
2347: , pabv1.value
2348: , p_effective_start_date
2349: , p_effective_end_date
2350: from per_default_budget_values pabv1
2351: where pabv1.business_group_id = p_business_group_id
2352: and not exists (select 'already there'
2353: from per_assignment_budget_values_f pabv2
2354: where pabv2.assignment_id = p_assignment_id