APPS.BEN_DM_CREATE_TRANSFER_FILE SQL Statements

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

Line: 14

select 'BEN_DM_INPUT_FILE'||p_delimiter||
       input_file_id||p_delimiter||
       source_business_group_name||p_delimiter||
       source_national_identifier||p_delimiter||
       source_person_id||p_delimiter||
       target_person_id||p_delimiter||
       target_business_group_name||p_delimiter||
       target_national_identifier||p_delimiter||
       group_order||p_delimiter||
       person_type||p_delimiter||
       data_source||p_delimiter||
       status||p_delimiter
  from ben_dm_input_file;

Line: 30

select 'BEN_DM_RESOLVE_MAPPINGS'||p_delimiter||
       resolve_mapping_id||p_delimiter||
       table_name||p_delimiter||
       column_name||p_delimiter||
       source_id||p_delimiter||
       source_key||p_delimiter||
       target_id||p_delimiter||
       business_group_name||p_delimiter||
       mapping_type||p_delimiter||
       resolve_mapping_id1||p_delimiter||
       resolve_mapping_id2||p_delimiter||
       resolve_mapping_id3||p_delimiter||
       resolve_mapping_id4||p_delimiter||
       resolve_mapping_id5||p_delimiter||
       resolve_mapping_id6||p_delimiter||
       resolve_mapping_id7||p_delimiter
  from ben_dm_resolve_mappings;