[Home] [Help]
1912: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1913: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1914: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1915: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1916: from pqh_budget_details bud, hr_organization_units org
1917: where org.business_group_id = p_business_group_id
1918: and bud.organization_id = org.organization_id
1919: and bud.budget_version_id = p_budget_version_id;
1920: cursor c2 is select bud.position_id, bud.grade_id, bud.organization_id , bud.job_id,bud.budget_detail_id,
1935: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1936: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1937: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1938: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1939: from pqh_budget_details bud, hr_organization_units org
1940: where org.business_group_id = p_business_group_id
1941: and bud.organization_id = org.organization_id
1942: and pqh_budget.already_budgeted_org(bud.organization_id) = 'FALSE'
1943: and bud.budget_version_id = p_budget_version_id;
2680: from pqh_budgets bgt, pqh_worksheets wks
2681: where wks.budget_id = bgt.budget_id
2682: and wks.worksheet_id = p_worksheet_id;
2683: cursor c1 is select organization_id
2684: from hr_organization_units
2685: where business_group_id = p_business_group_id
2686: and date_from < l_budget_end_date
2687: and (date_to > l_budget_start_date or date_to is null)
2688: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE' ;
2692: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
2693: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
2694: union all
2695: select p_start_organization_id organization_id_child from dual )x,
2696: hr_organization_units
2697: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
2698: and date_from < l_budget_end_date
2699: and (date_to > l_budget_start_date or date_to is null)
2700: and organization_id = x.organization_id_child;
2766: from pqh_budgets bgt, pqh_worksheets wks
2767: where wks.budget_id = bgt.budget_id
2768: and wks.worksheet_id = p_worksheet_id;
2769: cursor c1 is select hier.organization_id_child
2770: from per_org_structure_elements hier, hr_organization_units org
2771: where hier.org_structure_version_id = p_org_hier_ver
2772: and org.date_from < l_budget_end_date
2773: and (org.date_to > l_budget_start_date or org.date_to is null)
2774: and org.organization_id = hier.organization_id_child
4712: p_org_hier_ver in number,
4713: p_copy_budget_periods in varchar2,
4714: p_rows_inserted out nocopy number) IS
4715: cursor c1 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id
4716: from pqh_budget_details bud, hr_organization_units org
4717: where org.business_group_id = p_business_group_id
4718: and bud.organization_id = org.organization_id
4719: and pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'
4720: and bud.budget_version_id = p_budget_version_id;
4729: where pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'
4730: and bud.budget_version_id = p_budget_version_id
4731: and bud.organization_id = x.organization_id_child;
4732: cursor c3 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id
4733: from pqh_budget_details bud, hr_organization_units org
4734: where org.business_group_id = p_business_group_id
4735: and bud.organization_id = org.organization_id
4736: and pqh_budget.already_budgeted_org(bud.organization_id) = 'FALSE'
4737: and bud.budget_version_id = p_budget_version_id;