DBA Data[Home] [Help]

APPS.BEN_DM_UTILITY dependencies on BEN_DM_ENTITY_RESULTS

Line 890: -- delete information from ben_dm_entity_results table.

886: LOOP
887: FETCH csr_c1 INTO l_phase_item_id, l_group_order;
888: EXIT WHEN csr_c1%NOTFOUND;
889: --
890: -- delete information from ben_dm_entity_results table.
891: --
892: delete from ben_dm_entity_results
893: where group_order = l_group_order;
894:

Line 892: delete from ben_dm_entity_results

888: EXIT WHEN csr_c1%NOTFOUND;
889: --
890: -- delete information from ben_dm_entity_results table.
891: --
892: delete from ben_dm_entity_results
893: where group_order = l_group_order;
894:
895: commit;
896: -- ?? Add EXCEPTIOn if no data found.

Line 1216: AND table_name = 'BEN_DM_ENTITY_RESULTS'

1212: p_column_name VARCHAR2) IS
1213: SELECT column_name
1214: FROM sys.all_tab_columns
1215: WHERE data_type = p_data_type
1216: AND table_name = 'BEN_DM_ENTITY_RESULTS'
1217: AND column_name not in ('ENTITY_RESULT_ID','MIGRATION_ID','TABLE_NAME','GROUP_ORDER')
1218: AND column_name not in (SELECT entity_result_column_name
1219: FROM ben_dm_column_mappings
1220: WHERE table_id = p_table_id)