DBA Data[Home] [Help]

APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on PQH_BUDGET_DETAILS

Line 1618: pqh_budget_details bdet,

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'
1622: and bud.budgeted_entity_cd = 'JOB'

Line 2227: pqh_budget_details bdet,

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'
2231: and bud.budgeted_entity_cd = 'GRADE'

Line 3683: pqh_budget_details bdet,

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,
3687: pqh_budget_sets bsets,