APPS.OKL_TXS_PVT dependencies on FND_LOOKUP_VALUES

Line 1013: FROM Fnd_Lookup_Values

1009: l_dummy_var VARCHAR2(1) := '?' ;
1010:
1011: CURSOR okl_txsv_tctc_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1012: SELECT 'x'
1013: FROM Fnd_Lookup_Values
1014: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1015: AND fnd_lookup_values.lookup_type = p_lookup_type;
1016: BEGIN
1017:

Line 1014: WHERE fnd_lookup_values.lookup_code = p_lookup_code

1010:
1011: CURSOR okl_txsv_tctc_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1012: SELECT 'x'
1013: FROM Fnd_Lookup_Values
1014: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1015: AND fnd_lookup_values.lookup_type = p_lookup_type;
1016: BEGIN
1017:
1018: IF (p_txsv_rec.tax_call_type_code <> OKL_API.G_MISS_CHAR AND p_txsv_rec.tax_call_type_code IS NOT NULL)

Line 1015: AND fnd_lookup_values.lookup_type = p_lookup_type;

1011: CURSOR okl_txsv_tctc_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1012: SELECT 'x'
1013: FROM Fnd_Lookup_Values
1014: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1015: AND fnd_lookup_values.lookup_type = p_lookup_type;
1016: BEGIN
1017:
1018: IF (p_txsv_rec.tax_call_type_code <> OKL_API.G_MISS_CHAR AND p_txsv_rec.tax_call_type_code IS NOT NULL)
1019: THEN

Line 1036: 'FND_LOOKUP_VALUES');

1032: 'tax_call_type_code',
1033: g_child_table_token ,
1034: 'OKL_TAX_SOURCES_V',
1035: g_parent_table_token ,
1036: 'FND_LOOKUP_VALUES');
1037: l_return_status := OKC_API.G_RET_STS_ERROR;
1038:
1039: END IF;
1040:

Line 1176: FROM fnd_lookup_values

1172: l_dummy_var VARCHAR2(1) := '?' ;
1173:
1174: CURSOR okl_txsv_tlsc_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1175: SELECT 'x'
1176: FROM fnd_lookup_values
1177: WHERE lookup_code = p_lookup_code
1178: AND lookup_type = p_lookup_type;
1179:
1180: BEGIN

Line 1200: 'FND_LOOKUP_VALUES');

1196: 'tax_line_status_code',
1197: g_child_table_token ,
1198: 'OKL_TAX_SOURCES_V',
1199: g_parent_table_token ,
1200: 'FND_LOOKUP_VALUES');
1201: l_return_status := OKC_API.G_RET_STS_ERROR;
1202:
1203: END IF;
1204: