[Home] [Help]
1561:
1562: --get the budget_id and budget_unit_id
1563: cursor c_budget_id(p_business_group_id number) is
1564: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
1565: from pqh_budgets
1566: where position_control_flag = 'Y'
1567: and budgeted_entity_cd = 'POSITION'
1568: and business_group_id = l_business_group_id
1569: and p_effective_date between budget_start_date and budget_end_date