DBA Data[Home] [Help]

APPS.POA_SAVINGS_NP dependencies on DUAL

Line 595: select sysdate into l_start_time from dual;

591:
592: POA_LOG.debug_line('Opening cursor c_std_po');
593: POA_LOG.debug_line(' ');
594:
595: select sysdate into l_start_time from dual;
596: begin
597: select warehouse_currency_code,
598: rate_type
599: into

Line 679: select sysdate into l_end_time from dual;

675: -- POA_LOG.debug_line(' ');
676:
677: END LOOP;
678:
679: select sysdate into l_end_time from dual;
680: POA_LOG.put_line('Populate_npcontract: non one-time items with open blankets in batch '||p_batch_no || ' are ' || x_iteration);
681:
682: POA_LOG.put_line('Populate_npcontract: time to calculate lowest price: '||
683: poa_log.duration(l_end_time - l_start_time) || ', start time: ' ||