DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on HR_ORGANIZATION_UNITS

Line 989: from hr_positions pos,hr_organization_units org

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