APPS.PQH_BUDGET dependencies on HR_POSITIONS

Line 1531: from hr_positions

1527: for update of parent_worksheet_detail_id ,budget_unit1_percent,budget_unit2_percent,budget_unit3_percent;
1528:
1529: cursor c3(p_position_id number) is
1530: select organization_id
1531: from hr_positions
1532: where position_id = p_position_id;
1533: cursor c2 is select organization_id_child
1534: from per_org_structure_elements
1535: where org_structure_version_id = p_org_str_id

Line 2583: from hr_positions

2579: from pqh_budgets bgt, pqh_worksheets wks
2580: where wks.budget_id = bgt.budget_id
2581: and wks.worksheet_id = p_worksheet_id;
2582: cursor c1 is select position_id,job_id,organization_id,availability_status_id
2583: from hr_positions
2584: where business_group_id = p_business_group_id
2585: and effective_start_date < l_budget_end_date
2586: and effective_end_date > l_budget_start_date ;
2587: cursor csr_orgs is select organization_id_child

Line 2598: from hr_positions

2594: union all
2595: select p_start_organization_id organization_id_child from dual;
2596: cursor csr_pos(p_organization_id number) is
2597: select position_id,job_id,organization_id,availability_status_id
2598: from hr_positions
2599: where effective_start_date < l_budget_end_date
2600: and effective_end_date > l_budget_start_date
2601: and organization_id = p_organization_id;
2602: l_rows_inserted number := 0;