1847: l_found VARCHAR2(1);
1848: l_app_id NUMBER := 0;
1849: l_view_app_id NUMBER := 0;
1850:
1851: CURSOR tax_line_id_csr(p_tax_line_id zx_lines.TAX_LINE_ID%TYPE) IS
1852: SELECT '1'
1853: FROM zx_lines
1854: WHERE TAX_LINE_ID = p_tax_line_id;
1855:
1849: l_view_app_id NUMBER := 0;
1850:
1851: CURSOR tax_line_id_csr(p_tax_line_id zx_lines.TAX_LINE_ID%TYPE) IS
1852: SELECT '1'
1853: FROM zx_lines
1854: WHERE TAX_LINE_ID = p_tax_line_id;
1855:
1856: BEGIN
1857: -- initialize return status