DBA Data[Home] [Help]

APPS.PQH_BUDGET dependencies on PER_GRADES

Line 2477: cursor c1 is select grade_id from per_grades a

2473: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
2474: from pqh_budgets bge, pqh_worksheets wks
2475: where wks.budget_id = bge.budget_id
2476: and wks.worksheet_id = p_worksheet_id;
2477: cursor c1 is select grade_id from per_grades a
2478: where business_group_id = p_business_group_id
2479: and ((nvl(l_valid_grade_flag,'N') = 'Y' and l_budget_entity_cd = 'GRADE' and
2480: a.grade_id in (select b.grade_id from per_valid_grades b
2481: where b.date_from < l_budget_end_date