DBA Data[Home] [Help]

APPS.PA_XLA_SWEEP_TXN_PKG dependencies on DUAL

Line 766: FROM dual

762: AND cdl_raw.line_num = 1
763: AND g_cdl_line_type(i) ='R'
764: UNION ALL
765: SELECT g_document_header_id(i),g_document_distribution_id(i),g_expenditure_type(i)
766: FROM dual
767: WHERE g_cdl_line_type(i) ='D' )
768: AND bc_cm.transfer_status_code = 'A'
769: AND bc_cm.bc_event_id = g_cdl_acct_event_id(i)
770: AND bc_cm.document_type = 'AP'

Line 797: FROM dual

793: AND ei_raw.system_linkage_function in ('ST','OT','VI')
794: AND g_cdl_line_type(i) ='R'
795: UNION ALL
796: SELECT g_expenditure_item_id(i),g_expenditure_type(i)
797: FROM dual
798: WHERE g_system_linkage_function(i) IN ('ST','OT','VI')
799: AND g_cdl_line_type(i) ='D')
800: AND bc_cm.transfer_status_code in ('P','R','X')
801: AND bc_cm.document_type = 'PO'