APPS.BEN_DM_CREATE_CONTROL_FILES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 87

select tab.table_name,
       tab.column_name
  from sys.all_tab_columns tab
 where tab.table_name in ('BEN_DM_INPUT_FILE','BEN_DM_RESOLVE_MAPPINGS')
   and tab.column_name not in
      ('LAST_UPDATE_DATE',
       'LAST_UPDATED_BY',
       'LAST_UPDATE_LOGIN',
       'CREATED_BY',
       'CREATION_DATE')
order by tab.table_name,tab.column_id;

Line: 101

select tab.table_name,
       tab.column_name
  from sys.all_tab_columns tab
 where tab.table_name in ('BEN_DM_ENTITY_RESULTS')
   and tab.column_name not in
      ('LAST_UPDATE_DATE',
       'LAST_UPDATED_BY',
       'LAST_UPDATE_LOGIN',
       'CREATED_BY',
       'CREATION_DATE')
order by tab.column_id;

Line: 115

select tab.table_name,
       tab.column_name
  from ben_dm_tables bdt,
       ben_dm_column_mappings map,
       sys.all_tab_columns tab
 where tab.table_name in ('PER_ALL_PEOPLE_F')
   and bdt.table_name = tab.table_name
   and map.table_id = bdt.table_id
   and map.column_name = tab.column_name
order by tab.column_id;

Line: 128

select tab.table_name,
       tab.column_name
  from ben_dm_tables bdt,
       ben_dm_column_mappings map,
       sys.all_tab_columns tab
 where tab.table_name in
('PER_CONTACT_RELATIONSHIPS',
 'PER_ALL_ASSIGNMENTS_F',
 'BEN_PTNL_LER_FOR_PER',
 'BEN_PER_IN_LER',
 'BEN_PIL_ELCTBL_CHC_POPL')
   and bdt.table_name = tab.table_name
   and map.table_id = bdt.table_id
   and map.column_name = tab.column_name
order by tab.table_name,tab.column_id;

Line: 146

select tab.table_name,
       tab.column_name
  from ben_dm_tables bdt,
       ben_dm_column_mappings map,
       sys.all_tab_columns tab
 where tab.table_name in
('PER_ADDRESSES',
 'PER_PERIODS_OF_SERVICE',
 'PER_PERSON_TYPE_USAGES_F',
 'PER_ASSIGNMENT_EXTRA_INFO',
 'PAY_ELEMENT_ENTRIES_F',
 'PAY_ELEMENT_ENTRY_VALUES_F',
 'PAY_RUN_RESULTS',
 'PAY_RUN_RESULT_VALUES',
 'BEN_CBR_QUALD_BNF',
 'BEN_CBR_PER_IN_LER',
 'BEN_PER_CM_F',
 'BEN_PER_CM_PRVDD_F',
 'BEN_PER_CM_TRGR_F',
 'BEN_PER_CM_USG_F',
 'BEN_PER_BNFTS_BAL_F',
 'BEN_PRTT_ENRT_RSLT_F',
 'BEN_PRTT_PREM_F',
 'BEN_PRTT_PREM_BY_MO_F',
 'BEN_PRTT_RT_VAL',
 'BEN_ELIG_CVRD_DPNT_F',
 'BEN_ELIG_DPNT',
 'BEN_PRTT_ENRT_ACTN_F',
 'BEN_PRTT_ENRT_CTFN_PRVDD_F',
 'BEN_ENRT_BNFT',
 'BEN_ENRT_PREM',
 'BEN_ENRT_RT',
 'BEN_ELCTBL_CHC_CTFN',
 'BEN_LE_CLSN_N_RSTR',
 'BEN_PRMRY_CARE_PRVDR_F',
 'PER_ABSENCE_ATTENDANCES')
   and bdt.table_name = tab.table_name
   and map.table_id = bdt.table_id
   and map.column_name = tab.column_name
order by tab.table_name,tab.column_id;

Line: 189

select tab.table_name,
       tab.column_name
  from ben_dm_tables bdt,
       ben_dm_column_mappings map,
       sys.all_tab_columns tab
 where tab.table_name in
('BEN_ELIG_PER_F',
 'BEN_ELIG_PER_OPT_F')
   and bdt.table_name = tab.table_name
   and map.table_id = bdt.table_id
   and map.column_name = tab.column_name
order by tab.table_name,tab.column_id;

Line: 204

select tab.table_name,
       tab.column_name
  from ben_dm_tables bdt,
       ben_dm_column_mappings map,
       sys.all_tab_columns tab
 where tab.table_name in
('BEN_ELIG_PER_ELCTBL_CHC')
   and bdt.table_name = tab.table_name
   and map.table_id = bdt.table_id
   and map.column_name = tab.column_name
order by tab.table_name,tab.column_id;

Line: 323

l_in_file.delete;

Line: 410

l_in_file.delete;

Line: 462

l_in_file.delete;

Line: 514

l_in_file.delete;

Line: 562

select index_name,
       owner
  from sys.all_indexes
 where (index_name like 'BEN%'
        or index_name like 'HR%'
        or index_name like 'PAY%'
        or index_name like 'PER%')
  and status = 'UNUSABLE';