APPS.PQH_BDGT_POOL_REALLOCTIONS_API dependencies on PQH_BUDGET_POOLS

Line 414: FROM pqh_budget_pools txn,

410: WHERE txndtl.reallocation_id = p_txn_detail_id;
411: l_transaction_id NUMBER(15);
412: Cursor csr_dup_rcvr_period(p_transaction_id NUMBER) IS
413: SELECT 1
414: FROM pqh_budget_pools txn,
415: pqh_bdgt_pool_realloctions txndtl,
416: pqh_bdgt_pool_realloctions txnprd
417: WHERE txn.pool_id = p_transaction_id
418: AND txndtl.pool_id = txn.pool_id

Line 596: FROM pqh_budget_pools txn,

592: WHERE txndtl.reallocation_id = p_txn_detail_id;
593: l_transaction_id NUMBER(15);
594: Cursor csr_dup_rcvr_period(p_transaction_id NUMBER) IS
595: SELECT 1
596: FROM pqh_budget_pools txn,
597: pqh_bdgt_pool_realloctions txndtl,
598: pqh_bdgt_pool_realloctions txnprd
599: WHERE txn.pool_id = p_transaction_id
600: AND txndtl.pool_id = txn.pool_id