APPS.PQH_BUDGET dependencies on PER_VALID_GRADES

Line 2480: a.grade_id in (select b.grade_id from per_valid_grades b

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
2482: and (b.date_to > l_budget_start_date or b.date_to is null)))
2483: or (nvl(l_valid_grade_flag,'N') = 'N' and date_from < l_budget_end_date
2484: and (date_to > l_budget_start_date or date_to is null)));