DBA Data[Home] [Help]

APPS.HRI_PARAMETERS dependencies on PQH_BUDGET_VERSIONS

Line 887: from pqh_budgets b ,pqh_budget_versions bv

883: ) IS
884:
885: cursor c_bgt_id is
886: select b.budget_id, b.budget_name
887: from pqh_budgets b ,pqh_budget_versions bv
888: where b.business_group_id = g_bus_id
889: and b.budget_id = bv.budget_id
890: and trunc(sysdate) between bv.date_from and nvl( bv.date_to, sysdate+1 )
891: order by b.budget_name ;