DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on PER_GRADES

Line 866: cursor c1 is select grade_id from per_grades a

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