APPS.PER_SP_STAGE dependencies on PQH_COPY_ENTITY_TXNS

Line 98: pqh_copy_entity_txns_api.create_COPY_ENTITY_TXN

94: hr_utility.set_location('txn_cat doesnot exist',100);
95: raise;
96: end;
97: if l_sp_txn_cat is not null then
98: pqh_copy_entity_txns_api.create_COPY_ENTITY_TXN
99: (p_copy_entity_txn_id => p_copy_entity_txn_id
100: ,p_transaction_category_id => l_sp_txn_cat
101: ,p_context_business_group_id => p_business_group_id
102: ,p_context => 'SP'

Line 1152: delete from pqh_copy_entity_txns

1148: Delete from BEN_COPY_ENTITY_RESULTS
1149: where copy_entity_txn_id = p_copy_entity_txn_id
1150: and table_alias in ('SP','SCSR');
1151:
1152: delete from pqh_copy_entity_txns
1153: where copy_entity_txn_id = p_copy_entity_txn_id
1154: and context='SP';
1155:
1156: delete from hr_api_transactions

Line 1208: delete from pqh_copy_entity_txns

1204: end if;
1205:
1206: --
1207: --
1208: delete from pqh_copy_entity_txns
1209: where copy_entity_txn_id = p_copy_entity_txn_id;
1210:
1211: delete from hr_api_transactions
1212: where transaction_ref_id = p_copy_entity_txn_id