APPS.HZ_PARTY_STAGE_SHADOW dependencies on CONTAINS

Line 1214: AND CONTAINS (concat_col, 'dummy_string')>0;

1210: if create_index_flag = false and STAGE_NEW_TRANSFORMATIONS = false then
1211: BEGIN
1212: SELECT 1 INTO T FROM HZ_THIN_ST_PARTIES
1213: WHERE ROWNUM=1
1214: AND CONTAINS (concat_col, 'dummy_string')>0;
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN
1217: UPDATE HZ_DQM_STAGE_LOG
1218: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

Line 1239: AND CONTAINS (concat_col, 'dummy_string')>0;

1235: if create_index_flag = false and STAGE_NEW_TRANSFORMATIONS = false then
1236: BEGIN
1237: SELECT 1 INTO T FROM HZ_THIN_ST_PSITES
1238: WHERE ROWNUM=1
1239: AND CONTAINS (concat_col, 'dummy_string')>0;
1240: EXCEPTION
1241: WHEN NO_DATA_FOUND THEN
1242: UPDATE HZ_DQM_STAGE_LOG
1243: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

Line 1264: AND CONTAINS (concat_col, 'dummy_string')>0;

1260: if create_index_flag = false and STAGE_NEW_TRANSFORMATIONS = false then
1261: BEGIN
1262: SELECT 1 INTO T FROM HZ_THIN_ST_CONTACTS
1263: WHERE ROWNUM=1
1264: AND CONTAINS (concat_col, 'dummy_string')>0;
1265: EXCEPTION
1266: WHEN NO_DATA_FOUND THEN
1267: UPDATE HZ_DQM_STAGE_LOG
1268: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

Line 1289: AND CONTAINS (concat_col, 'dummy_string')>0;

1285: if create_index_flag = false then
1286: BEGIN
1287: SELECT 1 INTO T FROM HZ_THIN_ST_CPTS
1288: WHERE ROWNUM=1
1289: AND CONTAINS (concat_col, 'dummy_string')>0;
1290: EXCEPTION
1291: WHEN NO_DATA_FOUND THEN
1292: UPDATE HZ_DQM_STAGE_LOG
1293: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE