DBA Data[Home] [Help]

APPS.OKL_TTD_PVT dependencies on ZX_REGIMES_B

Line 1299: FROM zx_regimes_b

1295: l_dummy_var VARCHAR2(1) := '?' ;
1296:
1297: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
1298: SELECT 'x'
1299: FROM zx_regimes_b
1300: WHERE zx_regimes_b.tax_regime_id = p_id;
1301: BEGIN
1302:
1303: IF (p_ttdv_rec.tax_regime_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_regime_id IS NOT NULL)

Line 1300: WHERE zx_regimes_b.tax_regime_id = p_id;

1296:
1297: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
1298: SELECT 'x'
1299: FROM zx_regimes_b
1300: WHERE zx_regimes_b.tax_regime_id = p_id;
1301: BEGIN
1302:
1303: IF (p_ttdv_rec.tax_regime_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_regime_id IS NOT NULL)
1304: THEN

Line 1318: 'ZX_REGIMES_B');

1314: 'tax_regime_id',
1315: g_child_table_token ,
1316: 'OKL_TAX_TRX_DETAILS',
1317: g_parent_table_token ,
1318: 'ZX_REGIMES_B');
1319: l_return_status := OKC_API.G_RET_STS_ERROR;
1320:
1321: END IF;
1322: END IF;

Line 1347: FROM zx_regimes_b

1343: l_dummy_var VARCHAR2(1) := '?' ;
1344:
1345: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
1346: SELECT 'x'
1347: FROM zx_regimes_b
1348: WHERE zx_regimes_b.tax_regime_code = p_code;
1349: BEGIN
1350:
1351: IF (p_ttdv_rec.tax_regime_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_regime_code IS NOT NULL)

Line 1348: WHERE zx_regimes_b.tax_regime_code = p_code;

1344:
1345: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
1346: SELECT 'x'
1347: FROM zx_regimes_b
1348: WHERE zx_regimes_b.tax_regime_code = p_code;
1349: BEGIN
1350:
1351: IF (p_ttdv_rec.tax_regime_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_regime_code IS NOT NULL)
1352: THEN

Line 1366: 'ZX_REGIMES_B');

1362: 'tax_regime_code',
1363: g_child_table_token ,
1364: 'OKL_TAX_TRX_DETAILS',
1365: g_parent_table_token ,
1366: 'ZX_REGIMES_B');
1367: l_return_status := OKC_API.G_RET_STS_ERROR;
1368:
1369: END IF;
1370: END IF;

Line 2008: FROM zx_regimes_b

2004: l_okl_ttdv_app_id okl_ttdv_app_id_fk_csr%ROWTYPE;
2005:
2006: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
2007: SELECT 'x'
2008: FROM zx_regimes_b
2009: WHERE zx_regimes_b.tax_regime_id = p_id;
2010: l_okl_ttdv_tx_reg_id okl_ttdv_tx_reg_id_fk_csr%ROWTYPE;
2011:
2012: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS

Line 2009: WHERE zx_regimes_b.tax_regime_id = p_id;

2005:
2006: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
2007: SELECT 'x'
2008: FROM zx_regimes_b
2009: WHERE zx_regimes_b.tax_regime_id = p_id;
2010: l_okl_ttdv_tx_reg_id okl_ttdv_tx_reg_id_fk_csr%ROWTYPE;
2011:
2012: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
2013: SELECT 'x'

Line 2014: FROM zx_regimes_b

2010: l_okl_ttdv_tx_reg_id okl_ttdv_tx_reg_id_fk_csr%ROWTYPE;
2011:
2012: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
2013: SELECT 'x'
2014: FROM zx_regimes_b
2015: WHERE zx_regimes_b.tax_regime_code = p_code;
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

Line 2015: WHERE zx_regimes_b.tax_regime_code = p_code;

2011:
2012: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
2013: SELECT 'x'
2014: FROM zx_regimes_b
2015: WHERE zx_regimes_b.tax_regime_code = p_code;
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'