APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on PQH_BUDGETS

Line 498: from pqh_budgets

494: is
495: --
496: cursor c_budgets(p_start_date date, p_end_date date) is
497: select budget_id, budget_start_date, budget_end_date
498: from pqh_budgets
499: where
500: nvl(position_control_flag,'X') = 'Y'
501: and budgeted_entity_cd = 'POSITION'
502: and ((p_start_date <= budget_start_date

Line 554: from pqh_budgets bgt, pqh_budget_versions ver

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'

Line 1616: from pqh_budgets bud,

1612: --
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

Line 2225: from pqh_budgets bud,

2221: --
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

Line 3681: pqh_budgets bud,

3677: --
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,