APPS.POA_SAVINGS_MAIN dependencies on DUAL

Line 81: select sysdate into l_start_time from dual;

77: l_count NUMBER;
78: l_start_time date;
79: l_end_time date;
80: BEGIN
81: select sysdate into l_start_time from dual;
82: POA_LOG.debug_line('Populate_savings: entered');
83: POA_LOG.debug_line(' ');
84:
85: -- check if we need to populate the INC table poa_edw_po_dist_inc.

Line 106: select sysdate into l_end_time from dual;

102: INSERT INTO poa_edw_po_dist_inc (primary_key, seq_id,batch_id) values(l_primary_key(i),l_seq_id(i),l_batch_id(i));
103: EXIT WHEN l_count < l_batch_size;
104: end loop;
105: close v_changed_rows;
106: select sysdate into l_end_time from dual;
107: poa_log.put_line('time to populate incremental table: '|| poa_log.duration(l_end_time-l_start_time) || ', start time: ' || to_char(l_start_time, 'MM/DD/YYYY HH24:MI:SS') || ', end time: ' || to_char(l_end_time, 'MM/DD/YYYY HH24:MI:SS'));
108: end if;
109: -----------------------------------------------------------------------
110:

Line 128: SELECT sysdate INTO v_start_time from sys.dual;

124: x_progress := '020';
125:
126: select max(batch_id) into l_no_batch from poa_edw_po_dist_inc;
127:
128: SELECT sysdate INTO v_start_time from sys.dual;
129:
130: if (l_no_batch is NOT NULL) then
131: FOR v_batch_no IN 0..l_no_batch LOOP
132: poa_savings_np.populate_npcontract(p_start_date, p_end_date,

Line 140: select sysdate into l_end_time from dual;

136: commit;
137: END LOOP;
138: end if;
139:
140: select sysdate into l_end_time from dual;
141: poa_log.put_line('total time taken for bis savings : '||poa_log.duration(l_end_time-l_start_time));
142:
143: /* Loop through to get the account information for each
144: * distribution