DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PER_DEFAULT_BUDGET_VALUES

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

2347: hr_utility.set_location('hr_assignment.load_budget_values',1);
2348: --
2349: /* 25/05/95 Fixed bug 273820 - performance of following statement
2350: NB the business_group_id no longer needs +0 appended to it, this
2351: is because the view per_default_budget_values is in fact returning
2352: organization_id in place of business_group_id in ordre to make use
2353: of an index
2354: */
2355: -- Change to include effective start and end dates in parameters and logic to check these and

Line 2387: from per_default_budget_values pabv1

2383: , pabv1.unit
2384: , pabv1.value
2385: , p_effective_start_date
2386: , p_effective_end_date
2387: from per_default_budget_values pabv1
2388: where pabv1.business_group_id = p_business_group_id
2389: and not exists (select 'already there'
2390: from per_assignment_budget_values_f pabv2
2391: where pabv2.assignment_id = p_assignment_id