APPS.PQH_GSP_STAGE_TO_HR dependencies on PQH_COPY_ENTITY_TXNS

Line 1150: from pqh_copy_entity_txns

1146: l_bg_id number;
1147: begin
1148: select context_business_group_id
1149: into l_bg_id
1150: from pqh_copy_entity_txns
1151: where copy_entity_txn_id = p_copy_entity_txn_id;
1152: return l_bg_id;
1153: exception
1154: when no_data_found then

Line 1388: update pqh_copy_entity_txns

1384: hr_utility.set_location('post data push done ',40);
1385:
1386: begin
1387:
1388: update pqh_copy_entity_txns
1389: set status ='COMPLETED'
1390: where copy_entity_txn_id = p_copy_entity_txn_id;
1391:
1392: -- Purging the Copy Entity Txn record as it is no longer required --