eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BUDGET dependencies on PQH_BUDGET_PERIODS

Line 2897: from pqh_budget_periods

2893: budget_unit1_value,budget_unit2_value,budget_unit3_value,
2894: -- budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
2895: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
2896: budget_unit1_available,budget_unit2_available,budget_unit3_available
2897: from pqh_budget_periods
2898: where budget_detail_id = p_budget_detail_id;
2899: cursor c2(p_budget_period_id number) is
2900: select budget_set_id,dflt_budget_set_id,
2901: budget_unit1_value,budget_unit2_value,budget_unit3_value,

Line 4159: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe

4155: p_unit3_aggregate in varchar2) as
4156: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
4157: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
4158: prd.budget_unit3_value unit3_value
4159: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
4160: where prd.budget_detail_id = p_budget_detail_id
4161: and prd.start_time_period_id = tps.time_period_id
4162: and prd.end_time_period_id = tpe.time_period_id;
4163: l_proc varchar2(51) := g_package||'add_budgetrow';

Line 4188: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe

4184: p_unit3_aggregate in varchar2) as
4185: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
4186: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
4187: prd.budget_unit3_value unit3_value
4188: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
4189: where prd.budget_detail_id = p_budget_detail_id
4190: and prd.start_time_period_id = tps.time_period_id
4191: and prd.end_time_period_id = tpe.time_period_id;
4192: l_proc varchar2(51) := g_package||'sub_budgetrow';

Line 4622: from pqh_budget_periods

4618: procedure copy_budget_details(p_budget_detail_id in number,
4619: p_worksheet_detail_id in number) is
4620: cursor c1(p_budget_detail_id number) is
4621: select budget_period_id,start_time_period_id,end_time_period_id
4622: from pqh_budget_periods
4623: where budget_detail_id = p_budget_detail_id;
4624: cursor c2(p_budget_period_id number) is
4625: select budget_set_id,dflt_budget_set_id
4626: from pqh_budget_sets

Line 5111: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe

5107: p_budget_id in number) as
5108: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
5109: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
5110: prd.budget_unit3_value unit3_value
5111: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
5112: where prd.budget_detail_id = p_budget_detail_id
5113: and prd.start_time_period_id = tps.time_period_id
5114: and prd.end_time_period_id = tpe.time_period_id;
5115: l_proc varchar2(51) := g_package||'add_budgetrow';