APPS.ZX_TRL_SUMMARY_OVERRIDE_PKG dependencies on DUAL

Line 1803: SELECT zx_lines_s.NEXTVAL INTO l_tax_line_id FROM DUAL;

1799: THEN
1800:
1801: IF NVL(rec.associated_child_frozen_flag,'N') = 'Y' THEN
1802:
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;

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