DBA Data[Home] [Help]

APPS.ZX_TRL_SUMMARY_OVERRIDE_PKG dependencies on ZX_LINES_SUMMARY_S

Line 1807: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;

1803: SELECT zx_lines_s.NEXTVAL INTO l_tax_line_id FROM DUAL;
1804:
1805: -- new changes
1806: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
1807: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
1808: END IF;
1809: -- new changes
1810:
1811: SELECT max(abs(tax_apportionment_line_number))+1

Line 2238: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;

2234: -- OR l_existing_summary_tax_line_id is NOT NULL
2235: THEN
2236: l_had_frozen_dists := TRUE;
2237: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
2238: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
2239: END IF;
2240: END IF;
2241:
2242: -- update detail tax line with the new summary tax line id