DBA Data[Home] [Help]

APPS.PQH_BDGT dependencies on PQH_BUDGET_PERIODS

Line 269: from pqh_budget_periods

265: cursor c1 is select budget_period_id,budget_unit1_value,budget_unit2_value,budget_unit3_value,
266: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
267: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
268: budget_unit1_available,budget_unit2_available,budget_unit3_available
269: from pqh_budget_periods
270: where budget_detail_id = p_budget_detail_id
271: for update of budget_unit1_value,budget_unit2_value,budget_unit3_value,
272: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
273: budget_unit1_available,budget_unit2_available,budget_unit3_available ;

Line 453: update pqh_budget_periods

449: hr_utility.set_location('after period changes values '||l_proc,130);
450: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,133);
451: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,134);
452: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,135);
453: update pqh_budget_periods
454: set budget_unit1_value = l_period_unit1_value,
455: budget_unit2_value = l_period_unit2_value,
456: budget_unit3_value = l_period_unit3_value,
457: budget_unit1_percent = l_period_unit1_percent,