[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT tax_rate_id,
Rate_Type_Code,
percentage_rate,
quantity_rate
FROM ZX_SCO_RATES_B_V
WHERE tax_rate_code = c_tax_rate_code AND
tax = c_tax AND
tax_regime_code = c_tax_regime_code AND
tax_status_code = c_tax_status_code AND
active_flag = 'Y' AND
c_tax_determine_date >= effective_from AND
(c_tax_determine_date <= effective_to OR
effective_to IS NULL)
ORDER BY subscription_level_code;
SELECT tax_line_id
FROM ZX_LINES
WHERE APPLICATION_ID = p_offset_tax_line_rec.APPLICATION_ID
AND ENTITY_CODE = p_offset_tax_line_rec.ENTITY_CODE
AND EVENT_CLASS_CODE = p_offset_tax_line_rec.EVENT_CLASS_CODE
AND trx_id = p_offset_tax_line_rec.trx_id
AND trx_line_id = p_offset_tax_line_rec.trx_line_id
AND trx_level_type = p_offset_tax_line_rec.trx_level_type
AND tax_regime_code = p_offset_tax_line_rec.tax_regime_code
AND offset_link_to_tax_line_id = p_offset_tax_line_rec.offset_link_to_tax_line_id;
SELECT NVL(MAX(tax_line_number), 0) + 1
FROM zx_lines
WHERE application_id = p_offset_tax_line_rec.application_id
AND event_class_code = p_offset_tax_line_rec.event_class_code
AND entity_code = p_offset_tax_line_rec.entity_code
AND trx_id = p_offset_tax_line_rec.trx_id
AND trx_line_id = p_offset_tax_line_rec.trx_line_id
AND trx_level_type = p_offset_tax_line_rec.trx_level_type;
IF (p_offset_tax_line_rec.tax_event_type_code = 'UPDATE' OR
p_event_class_rec.tax_event_type_code = 'OVERRIDE_TAX') THEN
get_old_offset_tax_line_id(
p_event_class_rec,
p_offset_tax_line_rec,
l_old_offset_tax_line_id,
p_return_status,
p_error_buffer);