[Home] [Help]
550: ) is
551: --
552: cursor c_budgets(p_start_date date, p_end_date date, p_effective_date date) is
553: select bgt.budget_id, budget_version_id, budget_start_date, budget_end_date
554: from pqh_budgets bgt, pqh_budget_versions ver
555: where
556: bgt.budget_id = ver.budget_id
557: and (p_effective_date between date_from and date_to)
558: and nvl(position_control_flag,'X') = 'Y'
1613:
1614: cursor c_jobs(p_effective_date date, p_start_date1 date, p_end_date1 date) is
1615: select distinct bdet.job_id, job.name
1616: from pqh_budgets bud,
1617: pqh_budget_versions bver,
1618: pqh_budget_details bdet,
1619: per_jobs_tl job
1620: where bud.business_group_id = p_business_group_id
1621: and bud.position_control_flag = 'Y'
2222:
2223: cursor c_grades(p_effective_date date, p_start_date1 date, p_end_date1 date) is
2224: select distinct bdet.grade_id, grd.name
2225: from pqh_budgets bud,
2226: pqh_budget_versions bver,
2227: pqh_budget_details bdet,
2228: per_grades_tl grd
2229: where bud.business_group_id = p_business_group_id
2230: and bud.position_control_flag = 'Y'
3678: cursor c_currency is
3679: select bud.currency_code
3680: from
3681: pqh_budgets bud,
3682: pqh_budget_versions bver,
3683: pqh_budget_details bdet,
3684: pqh_budget_periods bper,
3685: per_time_periods stp,
3686: per_time_periods etp,