APPS.PQH_WKS_BUDGET dependencies on PQH_WORKSHEETS

Line 102: from pqh_budgets bgt,pqh_worksheets wks, pqh_worksheet_details wkd

98: p_unit1_desc out nocopy varchar2,
99: p_unit2_desc out nocopy varchar2,
100: p_unit3_desc out nocopy varchar2) is
101: cursor c1 is select budget_unit1_id,budget_unit2_id,budget_unit3_id
102: from pqh_budgets bgt,pqh_worksheets wks, pqh_worksheet_details wkd
103: where wkd.worksheet_id = wks.worksheet_id
104: and wks.budget_id = bgt.budget_id
105: and wkd.worksheet_detail_id = p_worksheet_detail_id;
106: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;

Line 214: from pqh_worksheets

210: from pqh_worksheet_details
211: where worksheet_detail_id = p_worksheet_detail_id ;
212: cursor c3(p_worksheet_id number) is
213: select propagation_method
214: from pqh_worksheets
215: where worksheet_id = p_worksheet_id ;
216: l_worksheet_detail_id number;
217: l_parent_worksheet_detail_id number;
218: l_worksheet_id number;

Line 313: cursor c1 is select propagation_method from pqh_worksheets

309: l_change_mode varchar2(3);
310: l_wks_change_mode varchar2(3);
311: l_effective_change_mode varchar2(3);
312: l_worksheet_id number;
313: cursor c1 is select propagation_method from pqh_worksheets
314: where worksheet_id = l_worksheet_id ;
315: begin
316: begin
317: open c0;

Line 391: from pqh_worksheets

387: p_unit1_precision out nocopy number,
388: p_unit2_precision out nocopy number,
389: p_unit3_precision out nocopy number ) is
390: cursor c1 is select budget_id
391: from pqh_worksheets
392: where worksheet_id = p_worksheet_id;
393: l_budget_id number;
394: begin
395: open c1;

Line 414: from pqh_worksheet_details wkd, pqh_worksheets wks

410: p_unit2_precision out nocopy number,
411: p_unit3_precision out nocopy number ) is
412: l_budget_id number;
413: cursor c1 is select wks.budget_id
414: from pqh_worksheet_details wkd, pqh_worksheets wks
415: where wkd.worksheet_detail_id = p_worksheet_detail_id
416: and wkd.worksheet_id = wks.worksheet_id;
417: begin
418: open c1;

Line 436: from pqh_worksheets wks, pqh_budgets bgt

432: p_unit1_aggregate out nocopy varchar2,
433: p_unit2_aggregate out nocopy varchar2,
434: p_unit3_aggregate out nocopy varchar2 ) is
435: cursor c1 is select bgt.budget_unit1_aggregate,bgt.budget_unit2_aggregate,bgt.budget_unit3_aggregate
436: from pqh_worksheets wks, pqh_budgets bgt
437: where wks.worksheet_id = p_worksheet_id
438: and wks.budget_id = bgt.budget_id;
439: begin
440: for i in c1 loop

Line 456: from pqh_worksheets wks, pqh_worksheet_details wkd, pqh_budgets bgt

452: p_unit1_aggregate out nocopy varchar2,
453: p_unit2_aggregate out nocopy varchar2,
454: p_unit3_aggregate out nocopy varchar2 ) is
455: cursor c1 is select bgt.budget_unit1_aggregate,bgt.budget_unit2_aggregate,bgt.budget_unit3_aggregate
456: from pqh_worksheets wks, pqh_worksheet_details wkd, pqh_budgets bgt
457: where wks.worksheet_id = wkd.worksheet_id
458: and wks.budget_id = bgt.budget_id
459: and wkd.worksheet_detail_id = p_worksheet_detail_id;
460: begin

Line 1216: cursor c1 is select budget_id from pqh_worksheets

1212: p_rows_inserted := null;
1213: raise;
1214: end populate_bud_organizations;
1215: function get_wks_budget( p_worksheet_id in number) return number is
1216: cursor c1 is select budget_id from pqh_worksheets
1217: where worksheet_id = p_worksheet_id;
1218: l_budget_id number;
1219: begin
1220: open c1;

Line 1498: from pqh_worksheets wks, pqh_worksheet_details wkd

1494: l_org_id number;
1495: l_transaction_name varchar2(300);
1496: cursor c1 is
1497: select wks.worksheet_name,wkd.organization_id
1498: from pqh_worksheets wks, pqh_worksheet_details wkd
1499: where wkd.worksheet_id = wks.worksheet_id
1500: and worksheet_detail_id = p_worksheet_detail_id
1501: and nvl(action_cd,'D') ='D';
1502: begin