DBA Data[Home] [Help]

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on DUAL

Line 2258: -- individual tax categories (in this case the tax group expansion will not take

2254:
2255: -- loop over original invoice's tax lines and call LTE for each tax line
2256: -- For example, if the invoice has a tax group which resulted in 3 tax lines, then
2257: -- this cursor will retrieve three racords and call the LTE three times, passing
2258: -- individual tax categories (in this case the tax group expansion will not take
2259: -- place inside the latin tax engine)
2260:
2261: Open c_inv_tax_lines(
2262: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_id_dist_tbl),

Line 4584: FROM dual;

4580: l_date := sysdate;
4581:
4582: SELECT zx_lines_s.NEXTVAL
4583: INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_line_id
4584: FROM dual;
4585:
4586: -- standard who columns
4587: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).CREATED_BY := l_user_id ;
4588: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).CREATION_DATE := l_date ; -- creation_date

Line 6261: FROM DUAL

6257:
6258:
6259: CURSOR sel_vat_tax_code_count IS
6260: SELECT 1
6261: FROM DUAL
6262: WHERE EXISTS ( SELECT tax_code
6263: FROM ar_vat_tax
6264: WHERE tax_code = tax_info_rec.tax_code
6265: AND set_of_books_id = sysinfo.sysparam.set_of_books_id