APPS.PQH_CBR_ENGINE dependencies on PQH_BDGT_POOL_REALLOCTIONS

Line 166: from pqh_bdgt_pool_realloctions

162: l_number number;
163: begin
164: select count(*)
165: into l_number
166: from pqh_bdgt_pool_realloctions
167: where pool_id = p_txn_id
168: and transaction_type = p_child_type;
169: return l_number;
170: exception

Line 182: from pqh_bdgt_pool_realloctions donor, pqh_bdgt_pool_realloctions period

178: p_rcvr_realloc_amt out nocopy number) is
179: begin
180: select sum(nvl(period.reallocation_amt,0)),sum(nvl(period.reserved_amt,0))
181: into p_donor_realloc_amt,p_donor_reserve_amt
182: from pqh_bdgt_pool_realloctions donor, pqh_bdgt_pool_realloctions period
183: where donor.pool_id = p_txn_id
184: and period.txn_detail_id = donor.reallocation_id
185: and donor.transaction_type = 'D'
186: and period.transaction_type = 'DD' ;

Line 190: from pqh_bdgt_pool_realloctions rcvr, pqh_bdgt_pool_realloctions period

186: and period.transaction_type = 'DD' ;
187:
188: select sum(nvl(period.reallocation_amt,0))
189: into p_rcvr_realloc_amt
190: from pqh_bdgt_pool_realloctions rcvr, pqh_bdgt_pool_realloctions period
191: where rcvr.pool_id = p_txn_id
192: and period.txn_detail_id = rcvr.reallocation_id
193: and rcvr.transaction_type = 'R'
194: and period.transaction_type = 'RD' ;

Line 885: from pqh_bdgt_pool_realloctions

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
885: from pqh_bdgt_pool_realloctions
886: where pool_id = p_txn_id
887: and transaction_type ='D' ;
888:
889: CURSOR csr_rcvr_rec(p_txn_id in number) is

Line 891: from pqh_bdgt_pool_realloctions

887: and transaction_type ='D' ;
888:
889: CURSOR csr_rcvr_rec(p_txn_id in number) is
890: select reallocation_id rcvr_id,entity_id
891: from pqh_bdgt_pool_realloctions
892: where pool_id = p_txn_id
893: and transaction_type ='R' ;
894:
895: CURSOR csr_donorperiod_rec(p_donor_id in number) is

Line 897: from pqh_bdgt_pool_realloctions

893: and transaction_type ='R' ;
894:
895: CURSOR csr_donorperiod_rec(p_donor_id in number) is
896: select reallocation_amt,reserved_amt,budget_period_id
897: from pqh_bdgt_pool_realloctions
898: where txn_detail_id = p_donor_id
899: and pool_id is null
900: and transaction_type ='DD' ;
901:

Line 904: from pqh_bdgt_pool_realloctions

900: and transaction_type ='DD' ;
901:
902: CURSOR csr_rcvrperiod_rec(p_rcvr_id in number) is
903: select reallocation_amt,entity_id,start_date,end_date,reallocation_id rcvr_period_id
904: from pqh_bdgt_pool_realloctions
905: where txn_detail_id = p_rcvr_id
906: and pool_id is null
907: and transaction_type ='RD' ;
908:

Line 1414: pqh_bdgt_pool_realloctions txndtl

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
1418: AND txn.pool_id = txndtl.pool_id;