APPS.PER_VACANCIES_PKG dependencies on PQH_BUDGET_DETAILS

Line 1584: from pqh_budget_details bdt,pqh_budget_versions bvr

1580:
1581: --get the budget_detail_id
1582: cursor c2(p_budget_id number) is
1583: select bdt.budget_detail_id
1584: from pqh_budget_details bdt,pqh_budget_versions bvr
1585: where bvr.budget_id = p_budget_id
1586: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date)
1587: and bdt.budget_version_id = bvr.budget_version_id
1588: and bdt.position_id = p_position_id;