APPS.OKL_TTD_PVT dependencies on ZX_JURISDICTIONS_B

Line 1491: FROM zx_jurisdictions_b

1487: l_dummy_var VARCHAR2(1) := '?' ;
1488:
1489: CURSOR okl_ttdv_tx_jur_id_fk_csr (p_id IN NUMBER) IS
1490: SELECT 'x'
1491: FROM zx_jurisdictions_b
1492: WHERE zx_jurisdictions_b.tax_jurisdiction_id = p_id;
1493: BEGIN
1494:
1495: IF (p_ttdv_rec.tax_jurisdiction_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_jurisdiction_id IS NOT NULL)

Line 1492: WHERE zx_jurisdictions_b.tax_jurisdiction_id = p_id;

1488:
1489: CURSOR okl_ttdv_tx_jur_id_fk_csr (p_id IN NUMBER) IS
1490: SELECT 'x'
1491: FROM zx_jurisdictions_b
1492: WHERE zx_jurisdictions_b.tax_jurisdiction_id = p_id;
1493: BEGIN
1494:
1495: IF (p_ttdv_rec.tax_jurisdiction_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_jurisdiction_id IS NOT NULL)
1496: THEN

Line 1510: 'ZX_JURISDICTIONS_B');

1506: 'tax_jurisdiction_id',
1507: g_child_table_token ,
1508: 'OKL_TAX_TRX_DETAILS',
1509: g_parent_table_token ,
1510: 'ZX_JURISDICTIONS_B');
1511: l_return_status := OKC_API.G_RET_STS_ERROR;
1512:
1513: END IF;
1514: END IF;

Line 2032: FROM zx_jurisdictions_b

2028: l_okl_ttdv_tx_st_id okl_ttdv_tx_st_id_fk_csr%ROWTYPE;
2029:
2030: CURSOR okl_ttdv_tx_jur_id_fk_csr (p_id IN NUMBER) IS
2031: SELECT 'x'
2032: FROM zx_jurisdictions_b
2033: WHERE zx_jurisdictions_b.tax_jurisdiction_id = p_id;
2034: l_okl_ttdv_tx_jur_id okl_ttdv_tx_jur_id_fk_csr%ROWTYPE;
2035:
2036: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS

Line 2033: WHERE zx_jurisdictions_b.tax_jurisdiction_id = p_id;

2029:
2030: CURSOR okl_ttdv_tx_jur_id_fk_csr (p_id IN NUMBER) IS
2031: SELECT 'x'
2032: FROM zx_jurisdictions_b
2033: WHERE zx_jurisdictions_b.tax_jurisdiction_id = p_id;
2034: l_okl_ttdv_tx_jur_id okl_ttdv_tx_jur_id_fk_csr%ROWTYPE;
2035:
2036: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2037: SELECT 'x'