APPS.ZX_TRL_SUMMARY_OVERRIDE_PKG dependencies on DUAL

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

1835: THEN
1836:
1837: IF NVL(rec.associated_child_frozen_flag,'N') = 'Y' THEN
1838:
1839: SELECT zx_lines_s.NEXTVAL INTO l_tax_line_id FROM DUAL;
1840:
1841: -- new changes
1842: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
1843: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;

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

1839: SELECT zx_lines_s.NEXTVAL INTO l_tax_line_id FROM DUAL;
1840:
1841: -- new changes
1842: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
1843: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
1844: END IF;
1845: -- new changes
1846:
1847: SELECT max(abs(tax_apportionment_line_number))+1

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

2289: -- OR l_existing_summary_tax_line_id is NOT NULL
2290: THEN
2291: l_had_frozen_dists := TRUE;
2292: IF l_summary_tax_line_id = p_summary_tax_line_id THEN
2293: SELECT zx_lines_summary_s.NEXTVAL INTO l_summary_tax_line_id FROM DUAL;
2294: END IF;
2295: END IF;
2296:
2297: -- update detail tax line with the new summary tax line id