APPS.PER_BUDGET_ELEMENTS_PKG dependencies on PER_BUDGET_VERSIONS

Line 341: from per_budget_versions pbv

337: WHERE org.organization_id = X_organization_id
338: AND org.business_group_id = X_business_group
339: AND org.internal_external_flag = 'INT'
340: AND org.date_from <= (select date_from
341: from per_budget_versions pbv
342: where pbv.budget_version_id = X_Budget_Version_Id)
343: AND nvl(org.date_to,hr_general.end_of_time) >= (select nvl(date_to,hr_general.end_of_time)
344: from per_budget_versions pbv
345: where pbv.budget_version_id = X_Budget_Version_Id);

Line 344: from per_budget_versions pbv

340: AND org.date_from <= (select date_from
341: from per_budget_versions pbv
342: where pbv.budget_version_id = X_Budget_Version_Id)
343: AND nvl(org.date_to,hr_general.end_of_time) >= (select nvl(date_to,hr_general.end_of_time)
344: from per_budget_versions pbv
345: where pbv.budget_version_id = X_Budget_Version_Id);
346:
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 372: FROM per_budget_versions pbv

368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: SELECT null
371: INTO l_result
372: FROM per_budget_versions pbv
373: WHERE pbv.budget_version_id = X_budget_version_id
374: AND pbv.business_group_id = X_Business_Group;
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 10);