APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_CREDITRTNGS_SG

Line 277: FROM HZ_IMP_CREDITRTNGS_SG

273: AND batch_mode_flag = p_batch_mode_flag
274: AND rownum = 1)
275: OR EXISTS (
276: SELECT 'Y'
277: FROM HZ_IMP_CREDITRTNGS_SG
278: WHERE batch_id = p_batch_id
279: AND batch_mode_flag = p_batch_mode_flag
280: AND rownum = 1)
281: OR EXISTS (

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

363:
364: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_PARTIES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
365: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
366: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTPTS_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';

Line 386: DELETE HZ_IMP_CREDITRTNGS_SG

382: AND batch_mode_flag = P_BATCH_MODE_FLAG;
383: DELETE HZ_IMP_CONTACTPTS_SG
384: WHERE batch_id = P_BATCH_ID
385: AND batch_mode_flag = P_BATCH_MODE_FLAG;
386: DELETE HZ_IMP_CREDITRTNGS_SG
387: WHERE batch_id = P_BATCH_ID
388: AND batch_mode_flag = P_BATCH_MODE_FLAG;
389: DELETE HZ_IMP_CLASSIFICS_SG
390: WHERE batch_id = P_BATCH_ID