DBA Data[Home] [Help]

APPS.PQH_BDGT dependencies on PQH_BUDGET_SETS

Line 535: from pqh_budget_sets

531: cursor c1 is select budget_unit1_value,budget_unit2_value,budget_unit3_value,
532: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
533: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
534: budget_unit1_available,budget_unit2_available,budget_unit3_available
535: from pqh_budget_sets
536: where budget_period_id = p_budget_period_id
537: for update of budget_unit1_value,budget_unit2_value,budget_unit3_value,
538: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
539: budget_unit1_available,budget_unit2_available,budget_unit3_available ;

Line 691: update pqh_budget_sets

687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);
690: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);
691: update pqh_budget_sets
692: set budget_unit1_value = l_budgetset_unit1_value,
693: budget_unit2_value = l_budgetset_unit2_value,
694: budget_unit3_value = l_budgetset_unit3_value,
695: budget_unit1_percent = l_budgetset_unit1_percent,