DBA Data[Home] [Help]

APPS.ZX_DEFAULT_AUTOMATION_PKG dependencies on RA_BATCH_SOURCES_ALL

Line 781: FROM RA_BATCH_SOURCES_ALL

777: BEGIN
778: SELECT nvl(global_attribute8,'0') global_attribute8,
779: to_char(to_date(global_attribute9,'YYYY/MM/DD HH24:MI:SS'),
780: 'RRRR-MON-DD') global_attribute9 INTO l_tax_invoice_number, l_tax_invoice_date
781: FROM RA_BATCH_SOURCES_ALL
782: WHERE batch_source_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_ID(p_trx_line_index)
783: AND NVL(org_id, -99) =
784: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_trx_line_index), -99);
785: EXCEPTION