APPS.PQH_CBR_ENGINE dependencies on PQH_BUDGET_POOLS

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,