DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on PER_GRADES

Line 870: cursor c1 is select grade_id from per_grades a

866: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
867: from pqh_budgets bgt, pqh_budget_versions bgv
868: where bgv.budget_id = bgt.budget_id
869: and bgv.budget_version_id = p_budget_version_id;
870: cursor c1 is select grade_id from per_grades a
871: where business_group_id = p_business_group_id
872: and ((nvl(l_valid_grade_flag,'N') = 'Y' and l_budgeted_entity_cd = 'GRADE' and
873: a.grade_id in (select b.grade_id from per_valid_grades b
874: where b.date_from < l_budget_end_date