APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on ZX_LINES_SUMMARY_S

Line 4166: FROM zx_lines_summary summ

4162: --
4163: UPDATE zx_detail_tax_lines_gt zlgt
4164: SET summary_tax_line_id =
4165: ( SELECT summary_tax_line_id
4166: FROM zx_lines_summary summ
4167: -- bug fix 5417887
4168: --WHERE summ.application_id = p_event_class_rec.application_id
4169: -- AND summ.entity_code = p_event_class_rec.entity_code
4170: -- AND summ.event_class_code = p_event_class_rec.event_class_code

Line 4433: zx_lines_summary_s.NEXTVAL,

4429: entity_code,
4430: event_class_code,
4431: trx_id,
4432: internal_organization_id,
4433: zx_lines_summary_s.NEXTVAL,
4434: count_detail_tax_line,
4435: trx_number,
4436: applied_from_application_id,
4437: applied_from_event_class_code,

Line 5239: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,

5235: event_class_code,
5236: trx_id,
5237: internal_organization_id,
5238: NVL(summary_tax_line_id,
5239: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
5240: count_detail_tax_line,
5241: trx_number,
5242: applied_from_application_id,
5243: applied_from_event_class_code,

Line 5705: zx_lines_summary_s.NEXTVAL,

5701: entity_code,
5702: event_class_code,
5703: trx_id,
5704: internal_organization_id,
5705: zx_lines_summary_s.NEXTVAL,
5706: count_detail_tax_line,
5707: trx_number,
5708: applied_from_application_id,
5709: applied_from_event_class_code,

Line 6477: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,

6473: -- retain the summary tax line id, then need to update the new summary
6474: -- tax line id back to zx_lines.
6475:
6476: SELECT NVL(summary_tax_line_id,
6477: zx_lines_summary_s.NEXTVAL ) summary_tax_line_id,
6478: trx_number,
6479: applied_from_application_id,
6480: applied_from_event_class_code,
6481: applied_from_entity_code,