APPS.PQH_CBR_ENGINE dependencies on PQH_BUDGET

Line 56: from pqh_budget_periods per,per_time_periods calstart, per_time_periods calend

52: begin
53: hr_utility.set_Location('inside'||l_proc,10);
54: select calstart.start_date,calend.end_date,budget_unit1_value,budget_unit2_value,budget_unit3_value
55: into l_prd_start_date,l_prd_end_date,l_unit1_value,l_unit2_value,l_unit3_value
56: from pqh_budget_periods per,per_time_periods calstart, per_time_periods calend
57: where budget_period_id = p_budget_period_id
58: and per.start_time_period_id = calstart.time_period_id
59: and per.end_time_period_id = calend.time_period_id;
60:

Line 221: from pqh_budgets bgt, pqh_budget_versions bvr

217: select bgt.budget_id,bgt.budget_name,bgt.budgeted_entity_cd,bgt.budget_start_date,
218: bgt.budget_end_date,bgt.currency_code,bgt.budget_unit1_id,bgt.budget_unit2_id,bgt.budget_unit3_id
219: into l_budget_id,p_budget_name,p_entity_type,p_budget_start_date,
220: p_budget_end_date,p_budget_currency,l_budget_unit1_id,l_budget_unit2_id,l_budget_unit3_id
221: from pqh_budgets bgt, pqh_budget_versions bvr
222: where bgt.budget_id = bvr.budget_id
223: and bvr.budget_version_id = p_budget_version_id
224: and bgt.position_control_flag ='Y';
225:

Line 228: p_budget_currency := pqh_budget.get_currency_cd(p_budget_id => l_budget_id);

224: and bgt.position_control_flag ='Y';
225:
226: -- business group currency to be used, in budget currency null
227: if p_budget_currency is null then
228: p_budget_currency := pqh_budget.get_currency_cd(p_budget_id => l_budget_id);
229: end if;
230:
231: -- unit num which is being reallocated
232: if l_budget_unit1_id = p_budget_unit_id then

Line 880: from pqh_budget_pools

876: l_num_txns number;
877:
878: CURSOR csr_txn_rec(p_folder_id in number) is
879: select pool_id txn_id,name
880: from pqh_budget_pools
881: where parent_pool_id = p_folder_id;
882:
883: CURSOR csr_donor_rec(p_txn_id in number) is
884: select reallocation_id donor_id,budget_detail_id,entity_id

Line 930: from pqh_budget_pools

926: pqh_bdgt_realloc_log_pkg.start_log(p_txn_entity_type => 'F',
927: p_folder_id => p_transaction_id);
928: hr_utility.set_location('plg flder started'||l_proc,20);
929: select count(*) into l_num_txns
930: from pqh_budget_pools
931: where parent_pool_id = p_transaction_id;
932: if nvl(l_num_txns,0) = 0 then
933: hr_utility.set_location('no txn '||l_proc,25);
934: p_status_flag := FALSE;

Line 1412: FROM pqh_budget_pools fld,

1408: SELECT txndtl.budget_detail_id budget_detail_id,
1409: txndtl.entity_id entity_id,
1410: txndtl.transaction_type txn_type,
1411: txndtl.pool_id txn_id
1412: FROM pqh_budget_pools fld,
1413: pqh_budget_pools txn,
1414: pqh_bdgt_pool_realloctions txndtl
1415: WHERE fld.pool_id = p_transaction_id
1416: AND fld.parent_pool_id IS NULL

Line 1413: pqh_budget_pools txn,

1409: txndtl.entity_id entity_id,
1410: txndtl.transaction_type txn_type,
1411: txndtl.pool_id txn_id
1412: FROM pqh_budget_pools fld,
1413: pqh_budget_pools txn,
1414: pqh_bdgt_pool_realloctions txndtl
1415: WHERE fld.pool_id = p_transaction_id
1416: AND fld.parent_pool_id IS NULL
1417: AND fld.pool_id = txn.parent_pool_id

Line 1522: FROM pqh_budget_pools

1518: hr_utility.set_location('inside '||l_proc,10);
1519: g_folder_id := p_transaction_id;
1520: SELECT budget_version_id,budget_unit_id,name,business_group_id
1521: into g_budget_version_id,l_budget_unit_id,g_folder_name,g_business_group_id
1522: FROM pqh_budget_pools
1523: WHERE pool_id = p_transaction_id
1524: and parent_pool_id is null;
1525: hr_utility.set_location('folder name '||g_folder_name,20);
1526: get_budget_details(p_budget_version_id => g_budget_version_id,