APPS.PQH_GSP_STAGE_TO_HR dependencies on PQH_COPY_ENTITY_TXNS

Line 1189: from pqh_copy_entity_txns

1185: l_bg_id number;
1186: begin
1187: select context_business_group_id
1188: into l_bg_id
1189: from pqh_copy_entity_txns
1190: where copy_entity_txn_id = p_copy_entity_txn_id;
1191: return l_bg_id;
1192: exception
1193: when no_data_found then

Line 1427: update pqh_copy_entity_txns

1423: hr_utility.set_location('post data push done ',40);
1424:
1425: begin
1426:
1427: update pqh_copy_entity_txns
1428: set status ='COMPLETED'
1429: where copy_entity_txn_id = p_copy_entity_txn_id;
1430:
1431: -- Purging the Copy Entity Txn record as it is no longer required --