APPS.BEN_DM_UTILITY dependencies on BEN_DM_TABLES

Line 1050: -- Description: Get table_id from ben_dm_tables for a given table_name

1046: --
1047:
1048:
1049: -- ------------------------- get_table_id ------------------------
1050: -- Description: Get table_id from ben_dm_tables for a given table_name
1051: --
1052: --
1053: -- Input Parameters
1054: -- p_table_name - table_name

Line 1138: FROM ben_dm_tables

1134: l_table_id NUMBER;
1135:
1136: CURSOR csr_tables IS
1137: SELECT table_id
1138: FROM ben_dm_tables
1139: WHERE table_name = p_table_name;
1140:
1141: --
1142: BEGIN

Line 1205: WHERE d1.table_id in (select table_id from ben_dm_tables where table_name = cols1.table_name)

1201: AND column_name not in ('REQUEST_ID','PROGRAM_APPLICATION_ID','PROGRAM_ID','PROGRAM_UPDATE_DATE')
1202: AND data_length < 2001
1203: AND not exists (SELECT null
1204: FROM BEN_DM_COLUMN_MAPPINGS d1
1205: WHERE d1.table_id in (select table_id from ben_dm_tables where table_name = cols1.table_name)
1206: AND column_name = cols1.column_name);
1207:
1208:
1209: -- Find next available Entity Result column