APPS.BEN_DM_DATA_UTIL dependencies on BEN_DM_COLUMN_MAPPINGS

Line 1617: from ben_dm_column_mappings

1613: l_table_id number ;
1614:
1615: cursor c2 is
1616: select column_mapping_id
1617: from ben_dm_column_mappings
1618: where table_id = l_table_id
1619: and column_name = p_column_name
1620: ;
1621: l_column_mapping_id number ;

Line 1643: update ben_dm_column_mappings

1639: fetch c2 into l_column_mapping_id ;
1640: if c2%found then
1641:
1642: hr_utility.set_location(' Insert :'||p_table_name, 10);
1643: update ben_dm_column_mappings
1644: set entity_result_column_name = entity_result_column_name
1645: where column_mapping_id = l_column_mapping_id
1646: ;
1647: else

Line 1649: insert into ben_dm_column_mappings

1645: where column_mapping_id = l_column_mapping_id
1646: ;
1647: else
1648: hr_utility.set_location(' Update :'||p_table_name, 10);
1649: insert into ben_dm_column_mappings
1650: ( column_mapping_id
1651: ,table_id
1652: ,column_name
1653: ,ENTITY_RESULT_COLUMN_NAME

Line 1660: ( ben_dm_column_mappings_s.nextval

1656: ,last_update_login
1657: ,created_by
1658: ,creation_date
1659: ) values
1660: ( ben_dm_column_mappings_s.nextval
1661: ,l_table_id
1662: ,p_column_name
1663: ,p_entity_result_column_name
1664: ,sysdate