[Home] [Help]
4429: --
4430: UPDATE zx_detail_tax_lines_gt zlgt
4431: SET summary_tax_line_id =
4432: ( SELECT summary_tax_line_id
4433: FROM zx_lines_summary summ
4434: -- bug fix 5417887
4435: --WHERE summ.application_id = p_event_class_rec.application_id
4436: -- AND summ.entity_code = p_event_class_rec.entity_code
4437: -- AND summ.event_class_code = p_event_class_rec.event_class_code
4696: entity_code,
4697: event_class_code,
4698: trx_id,
4699: internal_organization_id,
4700: zx_lines_summary_s.NEXTVAL,
4701: count_detail_tax_line,
4702: count_detail_cancel_flag,
4703: trx_number,
4704: applied_from_application_id,
5475: event_class_code,
5476: trx_id,
5477: internal_organization_id,
5478: NVL(summary_tax_line_id,
5479: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
5480: count_detail_tax_line,
5481: count_detail_cancel_flag,
5482: trx_number,
5483: applied_from_application_id,
5938: entity_code,
5939: event_class_code,
5940: trx_id,
5941: internal_organization_id,
5942: zx_lines_summary_s.NEXTVAL,
5943: count_detail_tax_line,
5944: count_detail_cancel_flag,
5945: trx_number,
5946: applied_from_application_id,
6760: -- retain the summary tax line id, then need to update the new summary
6761: -- tax line id back to zx_lines.
6762:
6763: SELECT NVL(summary_tax_line_id,
6764: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
6765: count_detail_tax_line,
6766: count_detail_cancel_flag,
6767: trx_number,
6768: applied_from_application_id,