DBA Data[Home] [Help]

APPS.PA_XLA_SWEEP_TXN_PKG dependencies on DUAL

Line 761: FROM dual

757: AND cdl_raw.line_num = 1
758: AND g_cdl_line_type(i) ='R'
759: UNION ALL
760: SELECT g_document_header_id(i),g_document_distribution_id(i),g_expenditure_type(i)
761: FROM dual
762: WHERE g_cdl_line_type(i) ='D' )
763: AND bc_cm.transfer_status_code = 'A'
764: AND bc_cm.bc_event_id = g_cdl_acct_event_id(i)
765: AND bc_cm.document_type = 'AP'

Line 792: FROM dual

788: AND ei_raw.system_linkage_function in ('ST','OT','VI')
789: AND g_cdl_line_type(i) ='R'
790: UNION ALL
791: SELECT g_expenditure_item_id(i),g_expenditure_type(i)
792: FROM dual
793: WHERE g_system_linkage_function(i) IN ('ST','OT','VI')
794: AND g_cdl_line_type(i) ='D')
795: AND bc_cm.transfer_status_code in ('P','R','X')
796: AND bc_cm.document_type = 'PO'