DBA Data[Home] [Help]

APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_TAX_DIST_ID_GT

Line 1365: | zx_tax_dist_id_gt and put all the returned tax distributions to PL/SQL table|

1361: | |
1362: | DESCRIPTION |
1363: | This procedure is used to reverse all the frozen tax distributions on UI, |
1364: | it reads all the reversed tax distribution ids from global temporary table |
1365: | zx_tax_dist_id_gt and put all the returned tax distributions to PL/SQL table|
1366: | p_rec_nrec_dist_tbl. UI needs to delete all the tax distributions uses want|
1367: | to freeze and insert all the tax distributions from p_rec_nrec_dist_tbl to |
1368: | tax reporsitory. |
1369: | |

Line 1384: WHERE rec_nrec_tax_dist_id IN (SELECT tax_dist_id FROM zx_tax_dist_id_gt);

1380:
1381: CURSOR get_rec_nrec_dist_cur is
1382: SELECT *
1383: FROM zx_rec_nrec_dist
1384: WHERE rec_nrec_tax_dist_id IN (SELECT tax_dist_id FROM zx_tax_dist_id_gt);
1385:
1386: BEGIN
1387:
1388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;