[Home] [Help]
1921: bud.budget_unit1_value,bud.budget_unit2_value,bud.budget_unit3_value,
1922: bud.budget_unit1_available,bud.budget_unit2_available,bud.budget_unit3_available,
1923: bud.budget_unit1_percent,bud.budget_unit2_percent,bud.budget_unit3_percent,
1924: bud.budget_unit1_value_type_cd,bud.budget_unit2_value_type_cd,bud.budget_unit3_value_type_cd
1925: from (select organization_id_child from pqh_worksheet_organizations_v
1926: where org_structure_version_id = p_org_hier_ver
1927: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
1928: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
1929: union all
1945: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1946: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1947: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1948: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1949: from (select organization_id_child from pqh_worksheet_organizations_v
1950: where org_structure_version_id = p_org_hier_ver
1951: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
1952: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
1953: union all
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
2588: from pqh_worksheet_organizations_v
2589: where org_structure_version_id = p_org_hier_ver
2590: connect by prior organization_id_child = organization_id_parent
2591: and org_structure_version_id = p_org_hier_ver
2592: start with organization_id_parent = p_start_organization_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' ;
2689: cursor c2 is select organization_id
2690: from (select organization_id_child from pqh_worksheet_organizations_v
2691: where org_structure_version_id = p_org_hier_ver
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
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;
4721: cursor c2 is select bud.position_id, bud.grade_id, bud.organization_id , bud.job_id,bud.budget_detail_id
4722: from (select organization_id_child from pqh_worksheet_organizations_v
4723: where org_structure_version_id = p_org_hier_ver
4724: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
4725: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
4726: union all
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;
4738: cursor c4 is select position_id, grade_id, organization_id , job_id,budget_detail_id
4739: from (select organization_id_child from pqh_worksheet_organizations_v
4740: where org_structure_version_id = p_org_hier_ver
4741: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
4742: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
4743: union all