APPS.PER_BUDGET_VALUES_PKG dependencies on PER_BUDGET_ELEMENTS

Line 55: FROM per_budget_elements pbe

51: hr_utility.set_location('Entering:'||l_proc, 5);
52: --
53: SELECT budget_version_id
54: INTO x_budget_version_id
55: FROM per_budget_elements pbe
56: WHERE pbe.budget_element_id = x_budget_element_id
57: AND pbe.business_group_id = x_business_group_id;
58: --
59: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1342: l_budget_version_id PER_BUDGET_ELEMENTS.BUDGET_VERSION_ID%TYPE;

1338: -- ----------------------------------------------------------------------------
1339: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
1340: l_proc VARCHAR2(72) := g_package||'Delete_Row';
1341: l_count NUMBER(7);
1342: l_budget_version_id PER_BUDGET_ELEMENTS.BUDGET_VERSION_ID%TYPE;
1343: l_ele_rowid VARCHAR2(255) := NULL;
1344:
1345: BEGIN
1346: --

Line 1352: FROM per_budget_elements

1348: --
1349: -- Determine the budget_type of the parent record
1350: SELECT budget_version_id
1351: INTO l_budget_version_id
1352: FROM per_budget_elements
1353: WHERE budget_element_id = (SELECT budget_element_id
1354: FROM per_budget_values
1355: WHERE rowid = X_Rowid);
1356: --

Line 1372: FROM per_budget_elements

1368: --
1369: IF l_count = 1 THEN
1370: SELECT rowid
1371: INTO l_ele_rowid
1372: FROM per_budget_elements
1373: WHERE budget_element_id = (SELECT budget_element_id
1374: FROM per_budget_values
1375: WHERE rowid = X_Rowid);
1376: END IF;

Line 1401: DELETE FROM per_budget_elements

1397: --
1398: -- delete the parent record also
1399: IF l_ele_rowid IS NOT NULL THEN
1400: --
1401: DELETE FROM per_budget_elements
1402: WHERE rowid = l_ele_rowid;
1403: --
1404: IF (SQL%NOTFOUND) then
1405: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');