DBA Data[Home] [Help]

APPS.HR_REPORTS dependencies on PER_BUDGET_VERSIONS

Line 220: l_budget_version_number per_budget_versions.version_number%type;

216: (p_budget_id NUMBER
217: ,p_budget_version_id NUMBER) return VARCHAR2
218: --
219: AS
220: l_budget_version_number per_budget_versions.version_number%type;
221: --
222: begin
223: --
224: hr_utility.trace('Entered Get_Budget_version');

Line 234: FROM per_budget_versions

230: begin
231: hr_utility.set_location('hr_reports.get_budget_version',5);
232: SELECT version_number
233: INTO l_budget_version_number
234: FROM per_budget_versions
235: WHERE budget_id = p_budget_id
236: AND budget_version_id = p_budget_version_id;
237: --
238: exception when NO_DATA_FOUND then null;