DBA Data[Home] [Help]

APPS.OKL_TTD_PVT dependencies on FND_CURRENCIES

Line 1539: FROM fnd_currencies

1535: l_dummy_var VARCHAR2(1) := '?' ;
1536:
1537: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
1538: SELECT 'x'
1539: FROM fnd_currencies
1540: WHERE fnd_currencies.currency_code = p_code;
1541: BEGIN
1542:
1543: IF (p_ttdv_rec.tax_currency_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_currency_code IS NOT NULL)

Line 1540: WHERE fnd_currencies.currency_code = p_code;

1536:
1537: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
1538: SELECT 'x'
1539: FROM fnd_currencies
1540: WHERE fnd_currencies.currency_code = p_code;
1541: BEGIN
1542:
1543: IF (p_ttdv_rec.tax_currency_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_currency_code IS NOT NULL)
1544: THEN

Line 1558: 'FND_CURRENCIES');

1554: 'tax_currency_code',
1555: g_child_table_token ,
1556: 'OKL_TAX_TRX_DETAILS',
1557: g_parent_table_token ,
1558: 'FND_CURRENCIES');
1559: l_return_status := OKC_API.G_RET_STS_ERROR;
1560:
1561: END IF;
1562: END IF;

Line 1587: FROM fnd_currencies

1583: l_dummy_var VARCHAR2(1) := '?' ;
1584:
1585: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
1586: SELECT 'x'
1587: FROM fnd_currencies
1588: WHERE fnd_currencies.currency_code = p_code;
1589: BEGIN
1590:
1591: IF (p_ttdv_rec.trx_currency_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.trx_currency_code IS NOT NULL)

Line 1588: WHERE fnd_currencies.currency_code = p_code;

1584:
1585: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
1586: SELECT 'x'
1587: FROM fnd_currencies
1588: WHERE fnd_currencies.currency_code = p_code;
1589: BEGIN
1590:
1591: IF (p_ttdv_rec.trx_currency_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.trx_currency_code IS NOT NULL)
1592: THEN

Line 1606: 'FND_CURRENCIES');

1602: 'trx_currency_code',
1603: g_child_table_token ,
1604: 'OKL_TAX_TRX_DETAILS',
1605: g_parent_table_token ,
1606: 'FND_CURRENCIES');
1607: l_return_status := OKC_API.G_RET_STS_ERROR;
1608:
1609: END IF;
1610: END IF;

Line 2038: FROM fnd_currencies

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'
2038: FROM fnd_currencies
2039: WHERE fnd_currencies.currency_code = p_code;
2040: l_okl_ttdv_tx_cur_cd okl_ttdv_tx_cur_cd_fk_csr%ROWTYPE;
2041:
2042: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS

Line 2039: WHERE fnd_currencies.currency_code = p_code;

2035:
2036: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2037: SELECT 'x'
2038: FROM fnd_currencies
2039: WHERE fnd_currencies.currency_code = p_code;
2040: l_okl_ttdv_tx_cur_cd okl_ttdv_tx_cur_cd_fk_csr%ROWTYPE;
2041:
2042: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2043: SELECT 'x'

Line 2044: FROM fnd_currencies

2040: l_okl_ttdv_tx_cur_cd okl_ttdv_tx_cur_cd_fk_csr%ROWTYPE;
2041:
2042: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2043: SELECT 'x'
2044: FROM fnd_currencies
2045: WHERE fnd_currencies.currency_code = p_code;
2046: l_okl_ttdv_trx_cur_cd_fk_csr okl_ttdv_trx_cur_cd_fk_csr%ROWTYPE;
2047:
2048:

Line 2045: WHERE fnd_currencies.currency_code = p_code;

2041:
2042: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2043: SELECT 'x'
2044: FROM fnd_currencies
2045: WHERE fnd_currencies.currency_code = p_code;
2046: l_okl_ttdv_trx_cur_cd_fk_csr okl_ttdv_trx_cur_cd_fk_csr%ROWTYPE;
2047:
2048:
2049: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;