APPS.PQH_UTILITY dependencies on PQH_BUDGETS

Line 1111: from pqh_budgets bgt,pqh_worksheets wks,

1107: p_unit1_desc out nocopy varchar2,
1108: p_unit2_desc out nocopy varchar2,
1109: p_unit3_desc out nocopy varchar2) is
1110: cursor c1 is select budget_unit1_id,budget_unit2_id,budget_unit3_id
1111: from pqh_budgets bgt,pqh_worksheets wks,
1112: pqh_worksheet_details wkd
1113: where wkd.worksheet_id = wks.worksheet_id
1114: and wks.budget_id = bgt.budget_id
1115: and wkd.worksheet_detail_id = p_worksheet_detail_id;

Line 1116: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;

1112: pqh_worksheet_details wkd
1113: where wkd.worksheet_id = wks.worksheet_id
1114: and wks.budget_id = bgt.budget_id
1115: and wkd.worksheet_detail_id = p_worksheet_detail_id;
1116: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;
1117: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
1118: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
1119: begin
1120: if p_worksheet_detail_id is not null then

Line 1117: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;

1113: where wkd.worksheet_id = wks.worksheet_id
1114: and wks.budget_id = bgt.budget_id
1115: and wkd.worksheet_detail_id = p_worksheet_detail_id;
1116: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;
1117: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
1118: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
1119: begin
1120: if p_worksheet_detail_id is not null then
1121: begin

Line 1118: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;

1114: and wks.budget_id = bgt.budget_id
1115: and wkd.worksheet_detail_id = p_worksheet_detail_id;
1116: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;
1117: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
1118: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
1119: begin
1120: if p_worksheet_detail_id is not null then
1121: begin
1122: open c1;