APPS.PQH_BUDGET dependencies on PQH_BUDGET_DETAILS

Line 1916: from pqh_budget_details bud, hr_organization_units org

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,

Line 1931: , pqh_budget_details bud

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
1930: select p_start_organization_id organization_id_child from dual )x
1931: , pqh_budget_details bud
1932: where bud.budget_version_id = p_budget_version_id
1933: and bud.organization_id = x.organization_id_child;
1934: cursor c3 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id,
1935: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 1939: from pqh_budget_details bud, hr_organization_units org

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;

Line 1955: , pqh_budget_details

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
1954: select p_start_organization_id organization_id_child from dual )x
1955: , pqh_budget_details
1956: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
1957: and budget_version_id = p_budget_version_id
1958: and organization_id = x.organization_id_child;
1959: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,

Line 1964: from pqh_budget_details

1960: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1961: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1962: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1963: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1964: from pqh_budget_details
1965: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
1966: and budget_version_id = p_budget_version_id;
1967: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,
1968: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 1972: from pqh_budget_details

1968: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1969: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1970: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1971: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1972: from pqh_budget_details
1973: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'
1974: and budget_version_id = p_budget_version_id;
1975: cursor c7 is select position_id ,grade_id, organization_id , job_id,budget_detail_id,
1976: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 1980: from pqh_budget_details

1976: budget_unit1_value,budget_unit2_value,budget_unit3_value,
1977: budget_unit1_available,budget_unit2_available,budget_unit3_available,
1978: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1979: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd
1980: from pqh_budget_details
1981: where budget_version_id = p_budget_version_id;
1982: l_budget_unit1_percent number(5,2);
1983: l_budget_unit2_percent number(5,2);
1984: l_budget_unit3_percent number(5,2);

Line 3396: from pqh_budget_details

3392: end pop_bud_tables;
3393: procedure pop_bud_tables(p_budget_version_id in number,
3394: p_budgeted_entity_cd in varchar) as
3395: cursor c1 is select position_id,job_id,organization_id,grade_id
3396: from pqh_budget_details
3397: where budget_version_id = p_budget_version_id;
3398: l_proc varchar2(100) := g_package||'pop_bud_tables' ;
3399: begin
3400: hr_utility.set_location('entering '||l_proc,10);

Line 4716: from pqh_budget_details bud, hr_organization_units org

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;

Line 4728: , pqh_budget_details bud

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
4727: select p_start_organization_id organization_id_child from dual )x
4728: , pqh_budget_details bud
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

Line 4733: from pqh_budget_details bud, hr_organization_units org

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;

Line 4745: , pqh_budget_details

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
4744: select p_start_organization_id organization_id_child from dual )x
4745: , pqh_budget_details
4746: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
4747: and budget_version_id = p_budget_version_id
4748: and organization_id = x.organization_id_child;
4749: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id

Line 4750: from pqh_budget_details

4746: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
4747: and budget_version_id = p_budget_version_id
4748: and organization_id = x.organization_id_child;
4749: cursor c5 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4750: from pqh_budget_details
4751: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
4752: and budget_version_id = p_budget_version_id;
4753: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4754: from pqh_budget_details

Line 4754: from pqh_budget_details

4750: from pqh_budget_details
4751: where pqh_budget.already_budgeted_job(job_id) = 'FALSE'
4752: and budget_version_id = p_budget_version_id;
4753: cursor c6 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4754: from pqh_budget_details
4755: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'
4756: and budget_version_id = p_budget_version_id;
4757: cursor c7 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4758: from pqh_budget_details

Line 4758: from pqh_budget_details

4754: from pqh_budget_details
4755: where pqh_budget.already_budgeted_grd(grade_id) = 'FALSE'
4756: and budget_version_id = p_budget_version_id;
4757: cursor c7 is select position_id ,grade_id, organization_id , job_id,budget_detail_id
4758: from pqh_budget_details
4759: where budget_version_id = p_budget_version_id;
4760: l_rows_inserted number := 0;
4761: l_proc varchar2(100) := g_package||'insert_from_budget' ;
4762: l_worksheet_detail_id number;