DBA Data[Home] [Help]

APPS.M4R_7B5_OSFM_PKG dependencies on DUAL

Line 541: FROM dual

537: BEGIN -- Checks if the line have changes
538:
539: SELECT COUNT(*)
540: INTO l_lines_chk
541: FROM dual
542: WHERE EXISTS ( (
543: SELECT po_header_id
544: FROM po_lines_archive_all
545: WHERE po_header_id = l_po_header_id

Line 693: FROM dual;

689: g_exception_tracking_msg := 'Query M4R_7B5_OSFM_S1 into l_doc_id';
690:
691: SELECT M4R_7B5_OSFM_S1.NEXTVAL
692: INTO l_doc_id
693: FROM dual;
694:
695: l_event_key := '7B5:'|| l_doc_id || to_char(cast(sysdate as timestamp),'DD/MM/YY:HHMMSS');
696:
697: IF (g_debug_level <= 1) THEN