DBA Data[Home] [Help]

APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_TAX_DIST_ID_GT

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

1326: | |
1327: | DESCRIPTION |
1328: | This procedure is used to reverse all the frozen tax distributions on UI, |
1329: | it reads all the reversed tax distribution ids from global temporary table |
1330: | zx_tax_dist_id_gt and put all the returned tax distributions to PL/SQL table|
1331: | p_rec_nrec_dist_tbl. UI needs to delete all the tax distributions uses want|
1332: | to freeze and insert all the tax distributions from p_rec_nrec_dist_tbl to |
1333: | tax reporsitory. |
1334: | |

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

1345:
1346: CURSOR get_rec_nrec_dist_cur is
1347: SELECT *
1348: FROM zx_rec_nrec_dist
1349: WHERE rec_nrec_tax_dist_id IN (SELECT tax_dist_id FROM zx_tax_dist_id_gt);
1350:
1351: BEGIN
1352:
1353: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;