APPS.PQH_COMMITMENT_PKG dependencies on PQH_BUDGET_VERSIONS

Line 178: From pqh_budget_versions bvr

174: Select bgt.budget_id,budget_name,period_set_name ,budgeted_entity_cd,
175: budget_start_date,budget_end_date
176: From pqh_budgets bgt
177: Where bgt.budget_id in (Select bvr.budget_id
178: From pqh_budget_versions bvr
179: Where bvr.budget_version_id = p_budget_version_id);
180: --
181: -- Obtain the frequency of the time periods for a calendar
182: --

Line 293: From pqh_budget_details bdt,pqh_budget_versions bvr

289: -- budget version.
290: --
291: Cursor csr_positions_in_bdgt(l_position_id in number) is
292: Select Position_id
293: From pqh_budget_details bdt,pqh_budget_versions bvr
294: Where bvr.budget_version_id = p_budget_version_id
295: AND bvr.budget_version_id = bdt.budget_version_id
296: AND bdt.position_id IS NOT NULL
297: AND (bdt.position_id = l_position_id or l_position_id IS NULL);

Line 301: From pqh_budget_details bdt,pqh_budget_versions bvr

297: AND (bdt.position_id = l_position_id or l_position_id IS NULL);
298: --
299: Cursor csr_orgs_in_bdgt(l_organization_id in number) is
300: Select Organization_id
301: From pqh_budget_details bdt,pqh_budget_versions bvr
302: Where bvr.budget_version_id = p_budget_version_id
303: AND bvr.budget_version_id = bdt.budget_version_id
304: AND bdt.organization_id IS NOT NULL
305: AND (bdt.organization_id = l_organization_id or l_organization_id IS NULL);

Line 309: From pqh_budget_details bdt,pqh_budget_versions bvr

305: AND (bdt.organization_id = l_organization_id or l_organization_id IS NULL);
306: --
307: Cursor csr_jobs_in_bdgt(l_job_id in number) is
308: Select Job_id
309: From pqh_budget_details bdt,pqh_budget_versions bvr
310: Where bvr.budget_version_id = p_budget_version_id
311: AND bvr.budget_version_id = bdt.budget_version_id
312: AND bdt.job_id IS NOT NULL
313: AND (bdt.job_id = l_job_id or l_job_id IS NULL);

Line 317: From pqh_budget_details bdt,pqh_budget_versions bvr

313: AND (bdt.job_id = l_job_id or l_job_id IS NULL);
314: --
315: Cursor csr_grades_in_bdgt(l_grade_id in number) is
316: Select Grade_id
317: From pqh_budget_details bdt,pqh_budget_versions bvr
318: Where bvr.budget_version_id = p_budget_version_id
319: AND bvr.budget_version_id = bdt.budget_version_id
320: AND bdt.grade_id IS NOT NULL
321: AND (bdt.grade_id = l_grade_id or l_grade_id IS NULL);

Line 2009: select budget_version_id from pqh_budget_versions

2005: -- This cursor is used to get the budget versions if there are no elements
2006: -- defined for a budget.
2007: --
2008: Cursor csr_bdgt_version is
2009: select budget_version_id from pqh_budget_versions
2010: where budget_id = p_budget_id;
2011: --
2012: l_budget_version_id number;
2013: --

Line 3082: Update pqh_budget_versions

3078: --
3079: End loop; /** All positions in budget as of passed effective date **/
3080: --
3081: --
3082: Update pqh_budget_versions
3083: set commitment_gl_status = g_budget_version_status
3084: where budget_version_id = p_budget_version_id;
3085: --
3086: --

Line 3711: from pqh_budget_versions

3707: --
3708: -- Get the effective Budget version
3709: Cursor csr_get_bdgt_version(p_budget_id number) IS
3710: Select budget_version_id
3711: from pqh_budget_versions
3712: where budget_id = p_budget_id
3713: and p_effective_date between date_from and date_to;
3714: --
3715: --