APPS.OKL_TBC_PVT dependencies on FND_LOOKUPS

Line 1318: FROM fnd_lookups

1314: l_dummy_var VARCHAR2(1) := '?' ;
1315:
1316: CURSOR okl_tbcv_res_type_fk_csr (p_id IN VARCHAR2) IS
1317: SELECT 'x'
1318: FROM fnd_lookups
1319: WHERE lookup_code = p_id
1320: AND lookup_type='OKL_TAX_ATTR_TYPE_CODE';
1321: BEGIN
1322:

Line 1337: 'FND_LOOKUPS');

1333: 'result_type_code',
1334: g_child_table_token ,
1335: 'OKL_TAX_ATTR_DEFINITIONS',
1336: g_parent_table_token ,
1337: 'FND_LOOKUPS');
1338: l_return_status := OKC_API.G_RET_STS_ERROR;
1339:
1340: END IF;
1341: END IF;

Line 1366: FROM fnd_lookups

1362: l_dummy_var VARCHAR2(1) := '?' ;
1363:
1364: CURSOR okl_tbcv_bc_fk_csr (p_id IN VARCHAR2) IS
1365: SELECT 'x'
1366: FROM fnd_lookups
1367: WHERE lookup_code = p_id
1368: AND lookup_type='OKL_BOOK_CLASS';
1369: BEGIN
1370:

Line 1385: 'FND_LOOKUPS');

1381: 'book_class_code',
1382: g_child_table_token ,
1383: 'OKL_TAX_ATTR_DEFINITIONS',
1384: g_parent_table_token ,
1385: 'FND_LOOKUPS');
1386: l_return_status := OKC_API.G_RET_STS_ERROR;
1387:
1388: END IF;
1389: END IF;

Line 1499: FROM fnd_lookups

1495: l_dummy_var VARCHAR2(1) := '?' ;
1496:
1497: CURSOR okl_tbcv_term_qtcode_fk_csr (p_id IN VARCHAR2) IS
1498: SELECT 'x'
1499: FROM fnd_lookups
1500: WHERE lookup_code = p_id
1501: AND lookup_type='OKL_QUOTE_TYPE';
1502:
1503: BEGIN

Line 1519: 'FND_LOOKUPS');

1515: 'term_quote_type_code',
1516: g_child_table_token ,
1517: 'OKL_TAX_ATTR_DEFINITIONS',
1518: g_parent_table_token ,
1519: 'FND_LOOKUPS');
1520: l_return_status := OKC_API.G_RET_STS_ERROR;
1521:
1522: END IF;
1523: END IF;

Line 1548: FROM fnd_lookups

1544: l_dummy_var VARCHAR2(1) := '?' ;
1545:
1546: CURSOR okl_tbcv_term_qrcode_fk_csr (p_id IN VARCHAR2) IS
1547: SELECT 'x'
1548: FROM fnd_lookups
1549: WHERE lookup_code = p_id
1550: AND lookup_type='OKL_QUOTE_REASON';
1551:
1552: BEGIN

Line 1568: 'FND_LOOKUPS');

1564: 'term_quote_reason_code',
1565: g_child_table_token ,
1566: 'OKL_TAX_ATTR_DEFINITIONS',
1567: g_parent_table_token ,
1568: 'FND_LOOKUPS');
1569: l_return_status := OKC_API.G_RET_STS_ERROR;
1570:
1571: END IF;
1572: END IF;

Line 1918: FROM fnd_lookups

1914: item_not_found_error EXCEPTION;
1915:
1916: CURSOR okl_tbcv_res_type_fk_csr (p_id IN VARCHAR2) IS
1917: SELECT 'x'
1918: FROM fnd_lookups
1919: WHERE lookup_code = p_id
1920: AND lookup_type='OKL_TAX_ATTR_TYPE_CODE';
1921: l_okl_tbcv_res_type okl_tbcv_res_type_fk_csr%ROWTYPE;
1922:

Line 1925: FROM fnd_lookups

1921: l_okl_tbcv_res_type okl_tbcv_res_type_fk_csr%ROWTYPE;
1922:
1923: CURSOR okl_tbcv_bc_fk_csr (p_id IN VARCHAR2) IS
1924: SELECT 'x'
1925: FROM fnd_lookups
1926: WHERE lookup_code = p_id
1927: AND lookup_type='OKL_BOOK_CLASS';
1928: l_okl_tbcv_bc okl_tbcv_bc_fk_csr%ROWTYPE;
1929:

Line 1938: FROM fnd_lookups

1934: l_okl_tbcv_tx_cntry_code okl_tbcv_tx_cntry_code_fk_csr%ROWTYPE;
1935:
1936: CURSOR okl_tbcv_term_qtcode_fk_csr (p_id IN VARCHAR2) IS
1937: SELECT 'x'
1938: FROM fnd_lookups
1939: WHERE lookup_code = p_id
1940: AND lookup_type='OKL_QUOTE_TYPE';
1941: l_okl_tbcv_term_qtcode okl_tbcv_term_qtcode_fk_csr%ROWTYPE;
1942:

Line 1945: FROM fnd_lookups

1941: l_okl_tbcv_term_qtcode okl_tbcv_term_qtcode_fk_csr%ROWTYPE;
1942:
1943: CURSOR okl_tbcv_term_qrcode_fk_csr (p_id IN VARCHAR2) IS
1944: SELECT 'x'
1945: FROM fnd_lookups
1946: WHERE lookup_code = p_id
1947: AND lookup_type='OKL_QUOTE_REASON';
1948: l_okl_tbcv_term_qrcode okl_tbcv_term_qrcode_fk_csr%ROWTYPE;
1949: