APPS.OKL_TTD_PVT dependencies on FND_LOOKUP_VALUES

Line 799: FROM Fnd_Lookup_Values

795: l_dummy_var VARCHAR2(1) := '?' ;
796:
797: CURSOR okl_ttdv_tctc_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
798: SELECT 'x'
799: FROM Fnd_Lookup_Values
800: WHERE fnd_lookup_values.lookup_code = p_lookup_code
801: AND fnd_lookup_values.lookup_type = p_lookup_type;
802: BEGIN
803:

Line 800: WHERE fnd_lookup_values.lookup_code = p_lookup_code

796:
797: CURSOR okl_ttdv_tctc_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
798: SELECT 'x'
799: FROM Fnd_Lookup_Values
800: WHERE fnd_lookup_values.lookup_code = p_lookup_code
801: AND fnd_lookup_values.lookup_type = p_lookup_type;
802: BEGIN
803:
804: IF (p_ttdv_rec.tax_call_type_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_call_type_code IS NOT NULL)

Line 801: AND fnd_lookup_values.lookup_type = p_lookup_type;

797: CURSOR okl_ttdv_tctc_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
798: SELECT 'x'
799: FROM Fnd_Lookup_Values
800: WHERE fnd_lookup_values.lookup_code = p_lookup_code
801: AND fnd_lookup_values.lookup_type = p_lookup_type;
802: BEGIN
803:
804: IF (p_ttdv_rec.tax_call_type_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_call_type_code IS NOT NULL)
805: THEN

Line 821: 'FND_LOOKUP_VALUES');

817: 'tax_call_type_code',
818: g_child_table_token ,
819: 'OKL_TAX_TRX_DETAILS',
820: g_parent_table_token ,
821: 'FND_LOOKUP_VALUES');
822: l_return_status := OKC_API.G_RET_STS_ERROR;
823:
824: END IF;
825: