APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_COPY_ENTITY_TXNS_VW

Line 16: from ben_copy_entity_txns_vw cet,

12: -- than BEN_PD_COPY_TO_BEN_TWO body , this would improve modularity and.
13:
14: cursor g_copy_entity_txn(c_copy_entity_txn_id number) is
15: select cet.row_type_cd row_type_cd
16: from ben_copy_entity_txns_vw cet,
17: PQH_TRANSACTION_CATEGORIES ptc
18: where cet.COPY_ENTITY_TXN_ID= c_copy_entity_txn_id
19: and ptc.TRANSACTION_CATEGORY_ID = cet.TRANSACTION_CATEGORY_ID;
20:

Line 22: g_row_type_cd ben_copy_entity_txns_vw.row_type_cd%type := null;

18: where cet.COPY_ENTITY_TXN_ID= c_copy_entity_txn_id
19: and ptc.TRANSACTION_CATEGORY_ID = cet.TRANSACTION_CATEGORY_ID;
20:
21: g_copy_entity_txn_id PQH_COPY_ENTITY_TXNS.COPY_ENTITY_TXN_ID%type := -999999;
22: g_row_type_cd ben_copy_entity_txns_vw.row_type_cd%type := null;
23: --TCS PDW Integration ENH
24:
25: procedure set_mapping(p_copy_entity_txn_id number) ;
26: --