APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PQH_COPY_ENTITY_TXNS

Line 8: from PQH_COPY_ENTITY_TXNS pcet,

4:
5: --Bug 5059695 Cursor to retreive the transaction category
6: cursor g_trasaction_categories(c_copy_entity_txn_id number) is
7: select ptc.short_name
8: from PQH_COPY_ENTITY_TXNS pcet,
9: PQH_TRANSACTION_CATEGORIES ptc
10: where pcet.COPY_ENTITY_TXN_ID= c_copy_entity_txn_id
11: and ptc.TRANSACTION_CATEGORY_ID = pcet.TRANSACTION_CATEGORY_ID;
12:

Line 13: g_copy_entity_txn_id PQH_COPY_ENTITY_TXNS.COPY_ENTITY_TXN_ID%type := -999999;

9: PQH_TRANSACTION_CATEGORIES ptc
10: where pcet.COPY_ENTITY_TXN_ID= c_copy_entity_txn_id
11: and ptc.TRANSACTION_CATEGORY_ID = pcet.TRANSACTION_CATEGORY_ID;
12:
13: g_copy_entity_txn_id PQH_COPY_ENTITY_TXNS.COPY_ENTITY_TXN_ID%type := -999999;
14: g_trasaction_category PQH_TRANSACTION_CATEGORIES.SHORT_NAME%type := null;
15:
16: -- End Bug 5059695
17: