[Home] [Help]
13089: and enabled_flag = 'Y'; --bmuthukr. R12 Need to upload only the enabled entries.
13090:
13091: cursor c_tca_columns is
13092: select flds.field_column_name , tca.column_name
13093: from ams_list_src_fields flds, AMS_DS_TCA_ENTITY_COLS tca,
13094: ams_list_headers_all hdr, ams_list_src_types typ
13095: where hdr.list_header_id = p_list_header_id
13096: and hdr.LIST_SOURCE_TYPE = typ.SOURCE_TYPE_CODE
13097: and typ.list_source_type_id = flds.list_source_type_id