APPS.ENI_DBI_PCO_LOAD_PKG dependencies on DUAL

Line 114: select sysdate into g_collection_date from dual;

110: l_last_collected_date := fnd_date.displayDT_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('ENI_DBI_PART_COUNT_F'));
111:
112: dbms_mview.refresh('ENI_DBI_BOM_COMPONENTS_MV1','F');
113:
114: select sysdate into g_collection_date from dual;
115: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PCO_WORKER_ASSIGNMENTS';
116:
117: -- Loop to Implode all the Modified Bills.
118: FOR r_modified_bill_of_materials IN c_modified_bill_of_materials(l_last_collected_date) LOOP

Line 248: SELECT sysdate into g_collection_date from dual;

244: FROM eni_dbi_pco_worker_assignments);
245: COMMIT;
246: END IF;
247:
248: SELECT sysdate into g_collection_date from dual;
249:
250: ELSIF (p_collect_mode = 'INCR') THEN
251: ENI_DBI_PCO_LOAD_PKG.collect_modified_bills;
252: -- procedure collects all the modified bills' information for incremental collection.

Line 469: FROM DUAL;

465:
466: SELECT NVL((SELECT 1 from eni_dbi_part_count_org_temp
467: where organization_id = p_organization_id),-1)
468: INTO l_org_exists
469: FROM DUAL;
470: IF (l_org_exists = -1) THEN
471: INSERT INTO eni_dbi_part_count_org_temp
472: (organization_id) VALUES (p_organization_id);
473: COMMIT;