DBA Data[Home] [Help]

APPS.ZX_DEFAULT_AUTOMATION_PKG dependencies on RA_BATCH_SOURCES_ALL

Line 573: FROM RA_BATCH_SOURCES_ALL

569: BEGIN
570: SELECT nvl(global_attribute8,'0') global_attribute8,
571: to_char(to_date(global_attribute9,'YYYY/MM/DD HH24:MI:SS'),
572: 'RRRR-MON-DD') global_attribute9 INTO l_tax_invoice_number, l_tax_invoice_date
573: FROM RA_BATCH_SOURCES_ALL
574: WHERE batch_source_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_ID(p_trx_line_index)
575: AND NVL(org_id, -99) =
576: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_trx_line_index), -99);
577: EXCEPTION