APPS.BEN_DM_CREATE_CONTROL_FILES dependencies on ALL_TAB_COLUMNS

Line 89: from sys.all_tab_columns tab

85:
86: cursor c1 is
87: select tab.table_name,
88: tab.column_name
89: from sys.all_tab_columns tab
90: where tab.table_name in ('BEN_DM_INPUT_FILE','BEN_DM_RESOLVE_MAPPINGS')
91: and tab.column_name not in
92: ('LAST_UPDATE_DATE',
93: 'LAST_UPDATED_BY',

Line 103: from sys.all_tab_columns tab

99:
100: cursor c2 is
101: select tab.table_name,
102: tab.column_name
103: from sys.all_tab_columns tab
104: where tab.table_name in ('BEN_DM_ENTITY_RESULTS')
105: and tab.column_name not in
106: ('LAST_UPDATE_DATE',
107: 'LAST_UPDATED_BY',

Line 119: sys.all_tab_columns tab

115: select tab.table_name,
116: tab.column_name
117: from ben_dm_tables bdt,
118: ben_dm_column_mappings map,
119: sys.all_tab_columns tab
120: where tab.table_name in ('PER_ALL_PEOPLE_F')
121: and bdt.table_name = tab.table_name
122: and map.table_id = bdt.table_id
123: and map.column_name = tab.column_name

Line 132: sys.all_tab_columns tab

128: select tab.table_name,
129: tab.column_name
130: from ben_dm_tables bdt,
131: ben_dm_column_mappings map,
132: sys.all_tab_columns tab
133: where tab.table_name in
134: ('PER_CONTACT_RELATIONSHIPS',
135: 'PER_ALL_ASSIGNMENTS_F',
136: 'BEN_PTNL_LER_FOR_PER',

Line 150: sys.all_tab_columns tab

146: select tab.table_name,
147: tab.column_name
148: from ben_dm_tables bdt,
149: ben_dm_column_mappings map,
150: sys.all_tab_columns tab
151: where tab.table_name in
152: ('PER_ADDRESSES',
153: 'PER_PERIODS_OF_SERVICE',
154: 'PER_PERSON_TYPE_USAGES_F',

Line 193: sys.all_tab_columns tab

189: select tab.table_name,
190: tab.column_name
191: from ben_dm_tables bdt,
192: ben_dm_column_mappings map,
193: sys.all_tab_columns tab
194: where tab.table_name in
195: ('BEN_ELIG_PER_F',
196: 'BEN_ELIG_PER_OPT_F')
197: and bdt.table_name = tab.table_name

Line 208: sys.all_tab_columns tab

204: select tab.table_name,
205: tab.column_name
206: from ben_dm_tables bdt,
207: ben_dm_column_mappings map,
208: sys.all_tab_columns tab
209: where tab.table_name in
210: ('BEN_ELIG_PER_ELCTBL_CHC')
211: and bdt.table_name = tab.table_name
212: and map.table_id = bdt.table_id