APPS.OKL_TTD_PVT dependencies on ZX_TAXES_B

Line 1395: FROM zx_taxes_b

1391: l_dummy_var VARCHAR2(1) := '?' ;
1392:
1393: CURSOR okl_ttdv_tx_id_fk_csr (p_id IN NUMBER) IS
1394: SELECT 'x'
1395: FROM zx_taxes_b
1396: WHERE zx_taxes_b.tax_id = p_id;
1397: BEGIN
1398:
1399: IF (p_ttdv_rec.tax_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_id IS NOT NULL)

Line 1396: WHERE zx_taxes_b.tax_id = p_id;

1392:
1393: CURSOR okl_ttdv_tx_id_fk_csr (p_id IN NUMBER) IS
1394: SELECT 'x'
1395: FROM zx_taxes_b
1396: WHERE zx_taxes_b.tax_id = p_id;
1397: BEGIN
1398:
1399: IF (p_ttdv_rec.tax_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_id IS NOT NULL)
1400: THEN

Line 1414: 'ZX_TAXES_B');

1410: 'tax_id',
1411: g_child_table_token ,
1412: 'OKL_TAX_TRX_DETAILS',
1413: g_parent_table_token ,
1414: 'ZX_TAXES_B');
1415: l_return_status := OKC_API.G_RET_STS_ERROR;
1416:
1417: END IF;
1418: END IF;

Line 2020: FROM zx_taxes_b

2016: l_okl_ttdv_tx_reg_cd okl_ttdv_tx_reg_cd_fk_csr%ROWTYPE;
2017:
2018: CURSOR okl_ttdv_tx_id_fk_csr (p_id IN NUMBER) IS
2019: SELECT 'x'
2020: FROM zx_taxes_b
2021: WHERE zx_taxes_b.tax_id = p_id;
2022: l_okl_ttdv_tx_id okl_ttdv_tx_id_fk_csr%ROWTYPE;
2023:
2024: CURSOR okl_ttdv_tx_st_id_fk_csr (p_id IN NUMBER) IS

Line 2021: WHERE zx_taxes_b.tax_id = p_id;

2017:
2018: CURSOR okl_ttdv_tx_id_fk_csr (p_id IN NUMBER) IS
2019: SELECT 'x'
2020: FROM zx_taxes_b
2021: WHERE zx_taxes_b.tax_id = p_id;
2022: l_okl_ttdv_tx_id okl_ttdv_tx_id_fk_csr%ROWTYPE;
2023:
2024: CURSOR okl_ttdv_tx_st_id_fk_csr (p_id IN NUMBER) IS
2025: SELECT 'x'