DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_PRVDR_LINE_EXTNS_GT

Line 1505: INSERT INTO ZX_PRVDR_LINE_EXTNS_GT (event_class_code,

1501: );
1502: END;
1503: ELSIF(p_service_type_code = 'DERIVE_LINE_ATTRS') THEN
1504: BEGIN
1505: INSERT INTO ZX_PRVDR_LINE_EXTNS_GT (event_class_code,
1506: application_id,
1507: entity_code,
1508: trx_id,
1509: trx_line_id,

Line 1536: FROM ZX_PRVDR_LINE_EXTNS_GT ext

1532: AND entity_code = p_event_class_rec.entity_code
1533: AND event_class_code = p_event_class_rec.event_class_code
1534: AND trx_id = p_event_class_rec.trx_id
1535: AND NOT EXISTS (SELECT 1
1536: FROM ZX_PRVDR_LINE_EXTNS_GT ext
1537: WHERE ext.application_id = lines.application_id
1538: AND ext.entity_code = lines.entity_code
1539: AND ext.event_class_code = lines.event_class_code
1540: AND ext.trx_id = lines.trx_id