APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_RELSHIPS_SG

Line 301: FROM HZ_IMP_RELSHIPS_SG

297: AND batch_mode_flag = p_batch_mode_flag
298: AND rownum = 1)
299: OR EXISTS (
300: SELECT 'Y'
301: FROM HZ_IMP_RELSHIPS_SG
302: WHERE batch_id = p_batch_id
303: AND batch_mode_flag = p_batch_mode_flag
304: AND rownum = 1)
305: OR EXISTS (

Line 371: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_RELSHIPS_SG TRUNCATE PARTITION batchpar DROP STORAGE';

367: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CREDITRTNGS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
368: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CLASSIFICS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
369: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINREPORTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
370: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINNUMBERS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
371: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_RELSHIPS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
372: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
373: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTROLES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
374: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSUSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
375:

Line 398: DELETE HZ_IMP_RELSHIPS_SG

394: AND batch_mode_flag = P_BATCH_MODE_FLAG;
395: DELETE HZ_IMP_FINNUMBERS_SG
396: WHERE batch_id = P_BATCH_ID
397: AND batch_mode_flag = P_BATCH_MODE_FLAG;
398: DELETE HZ_IMP_RELSHIPS_SG
399: WHERE batch_id = P_BATCH_ID
400: AND batch_mode_flag = P_BATCH_MODE_FLAG;
401: DELETE HZ_IMP_CONTACTS_SG
402: WHERE batch_id = P_BATCH_ID