APPS.OKL_TTD_PVT dependencies on ZX_STATUS_B

Line 1443: FROM zx_status_b

1439: l_dummy_var VARCHAR2(1) := '?' ;
1440:
1441: CURSOR okl_ttdv_tx_st_id_fk_csr (p_id IN NUMBER) IS
1442: SELECT 'x'
1443: FROM zx_status_b
1444: WHERE zx_status_b.tax_status_id = p_id;
1445: BEGIN
1446:
1447: IF (p_ttdv_rec.tax_status_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_status_id IS NOT NULL)

Line 1444: WHERE zx_status_b.tax_status_id = p_id;

1440:
1441: CURSOR okl_ttdv_tx_st_id_fk_csr (p_id IN NUMBER) IS
1442: SELECT 'x'
1443: FROM zx_status_b
1444: WHERE zx_status_b.tax_status_id = p_id;
1445: BEGIN
1446:
1447: IF (p_ttdv_rec.tax_status_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_status_id IS NOT NULL)
1448: THEN

Line 1462: 'ZX_STATUS_B');

1458: 'tax_status_id',
1459: g_child_table_token ,
1460: 'OKL_TAX_TRX_DETAILS',
1461: g_parent_table_token ,
1462: 'ZX_STATUS_B');
1463: l_return_status := OKC_API.G_RET_STS_ERROR;
1464:
1465: END IF;
1466: END IF;

Line 2026: FROM zx_status_b

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'
2026: FROM zx_status_b
2027: WHERE zx_status_b.tax_status_id = p_id;
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

Line 2027: WHERE zx_status_b.tax_status_id = p_id;

2023:
2024: CURSOR okl_ttdv_tx_st_id_fk_csr (p_id IN NUMBER) IS
2025: SELECT 'x'
2026: FROM zx_status_b
2027: WHERE zx_status_b.tax_status_id = p_id;
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'