DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on HR_ORGANIZATION_UNITS

Line 993: from hr_positions pos,hr_organization_units org

989: from pqh_budgets bgt, pqh_budget_versions bgv
990: where bgv.budget_id = bgt.budget_id
991: and bgv.budget_version_id = p_budget_version_id;
992: cursor c1 is select position_id,job_id,pos.organization_id organization_id
993: from hr_positions pos,hr_organization_units org
994: where org.business_group_id = p_business_group_id
995: and pos.business_group_id = p_business_group_id
996: and pos.organization_id = org.organization_id
997: and pos.effective_start_date < l_budget_end_date