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_WKS_BUDGET dependencies on PQH_BUDGETS

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 106: l_budget_unit1_id pqh_budgets.budget_unit1_id%type;

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;
107: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
108: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
109: begin
110: if p_worksheet_detail_id is not null then

Line 107: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;

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;
107: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
108: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
109: begin
110: if p_worksheet_detail_id is not null then
111: begin

Line 108: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;

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;
107: l_budget_unit2_id pqh_budgets.budget_unit1_id%type;
108: l_budget_unit3_id pqh_budgets.budget_unit1_id%type;
109: begin
110: if p_worksheet_detail_id is not null then
111: begin
112: open c1;

Line 343: from pqh_budgets

339: p_unit1_precision out nocopy number,
340: p_unit2_precision out nocopy number,
341: p_unit3_precision out nocopy number ) is
342: cursor c1 is select currency_code,budget_unit1_id,budget_unit2_id,budget_unit3_id
343: from pqh_budgets
344: where budget_id = p_budget_id;
345: l_currency_code varchar2(15);
346: l_unit1_id number;
347: l_unit2_id number;

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 859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;

855: p_business_group_id in number,
856: p_rows_inserted out nocopy number) is
857: l_budget_start_date date;
858: l_budget_end_date date;
859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
861:
862: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
863: from pqh_budgets bgt, pqh_budget_versions bgv

Line 860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;

856: p_rows_inserted out nocopy number) is
857: l_budget_start_date date;
858: l_budget_end_date date;
859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
861:
862: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
863: from pqh_budgets bgt, pqh_budget_versions bgv
864: where bgv.budget_id = bgt.budget_id

Line 863: from pqh_budgets bgt, pqh_budget_versions bgv

859: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
860: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
861:
862: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
863: from pqh_budgets bgt, pqh_budget_versions bgv
864: where bgv.budget_id = bgt.budget_id
865: and bgv.budget_version_id = p_budget_version_id;
866: cursor c1 is select grade_id from per_grades a
867: where business_group_id = p_business_group_id

Line 925: from pqh_budgets bgt, pqh_budget_versions bgv

921: p_rows_inserted out nocopy number) is
922: l_budget_start_date date;
923: l_budget_end_date date;
924: cursor c0 is select budget_start_date,budget_end_date
925: from pqh_budgets bgt, pqh_budget_versions bgv
926: where bgv.budget_id = bgt.budget_id
927: and bgv.budget_version_id = p_budget_version_id;
928: cursor c1 is select job_id from per_jobs job, per_job_groups jgr
929: where job.job_group_id = jgr.job_group_id and jgr.internal_name = 'HR_' || job.business_group_id

Line 985: from pqh_budgets bgt, pqh_budget_versions bgv

981: p_rows_inserted out nocopy number) is
982: l_budget_start_date date;
983: l_budget_end_date date;
984: cursor c0 is select budget_start_date,budget_end_date
985: from pqh_budgets bgt, pqh_budget_versions bgv
986: where bgv.budget_id = bgt.budget_id
987: and bgv.budget_version_id = p_budget_version_id;
988: cursor c1 is select position_id,job_id,pos.organization_id organization_id
989: from hr_positions pos,hr_organization_units org

Line 1097: from pqh_budgets bgt, pqh_budget_versions bgv

1093: p_rows_inserted out nocopy number) is
1094: l_budget_start_date date;
1095: l_budget_end_date date;
1096: cursor c0 is select budget_start_date,budget_end_date
1097: from pqh_budgets bgt, pqh_budget_versions bgv
1098: where bgv.budget_id = bgt.budget_id
1099: and bgv.budget_version_id = p_budget_version_id;
1100: cursor c1 is select organization_id
1101: from hr_all_organization_units

Line 1290: from pqh_budgets

1286: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1287: hr_utility.set_location('budget id is '||l_budget_id||l_proc,20);
1288: select period_set_name,budget_start_date,budget_end_date
1289: into l_calendar,l_budget_start_date,l_budget_end_date
1290: from pqh_budgets
1291: where budget_id = l_budget_id;
1292: hr_utility.set_location('calendar id is '||l_calendar||l_proc,30);
1293: hr_utility.set_location('budget start date is '||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,40);
1294: hr_utility.set_location('budget_end date id is '||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,50);

Line 1765: from pqh_budgets where budget_id = l_budget_id;

1761: fetch c_worksheet_detail into l_position_id,l_worksheet_detail_id;
1762: if c_worksheet_detail%found then
1763: l_budget_id := get_wkd_budget(p_worksheet_detail_id);
1764: select budgeted_entity_cd,budget_style_cd into l_budgeted_entity_cd,l_budget_style_cd
1765: from pqh_budgets where budget_id = l_budget_id;
1766: if l_budgeted_entity_cd ='POSITION' then
1767: if l_position_id is not null then
1768: update_wkd_pot(p_worksheet_detail_id => p_worksheet_detail_id);
1769: else