DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_PRVDR_LINE_EXTNS_GT

Line 1655: INSERT INTO ZX_PRVDR_LINE_EXTNS_GT (event_class_code,

1651: );
1652: END;
1653: ELSIF(p_service_type_code = 'DERIVE_LINE_ATTRS') THEN
1654: BEGIN
1655: INSERT INTO ZX_PRVDR_LINE_EXTNS_GT (event_class_code,
1656: application_id,
1657: entity_code,
1658: trx_id,
1659: trx_line_id,

Line 1686: FROM ZX_PRVDR_LINE_EXTNS_GT ext

1682: AND entity_code = p_event_class_rec.entity_code
1683: AND event_class_code = p_event_class_rec.event_class_code
1684: AND trx_id = p_event_class_rec.trx_id
1685: AND NOT EXISTS (SELECT 1
1686: FROM ZX_PRVDR_LINE_EXTNS_GT ext
1687: WHERE ext.application_id = lines.application_id
1688: AND ext.entity_code = lines.entity_code
1689: AND ext.event_class_code = lines.event_class_code
1690: AND ext.trx_id = lines.trx_id