APPS.OKL_CAF_PVT dependencies on FND_LOOKUP_VALUES

Line 519: FROM Fnd_Lookup_Values

515: l_dummy_var VARCHAR2(1) := '?' ;
516:
517: CURSOR okl_cafv_sts_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
518: SELECT 'x'
519: FROM Fnd_Lookup_Values
520: WHERE fnd_lookup_values.lookup_code = p_lookup_code
521: AND fnd_lookup_values.lookup_type = p_lookup_type;
522: BEGIN
523:

Line 520: WHERE fnd_lookup_values.lookup_code = p_lookup_code

516:
517: CURSOR okl_cafv_sts_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
518: SELECT 'x'
519: FROM Fnd_Lookup_Values
520: WHERE fnd_lookup_values.lookup_code = p_lookup_code
521: AND fnd_lookup_values.lookup_type = p_lookup_type;
522: BEGIN
523:
524: IF (p_cafv_rec.sts_code = OKL_API.G_MISS_CHAR OR p_cafv_rec.sts_code IS NULL)

Line 521: AND fnd_lookup_values.lookup_type = p_lookup_type;

517: CURSOR okl_cafv_sts_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
518: SELECT 'x'
519: FROM Fnd_Lookup_Values
520: WHERE fnd_lookup_values.lookup_code = p_lookup_code
521: AND fnd_lookup_values.lookup_type = p_lookup_type;
522: BEGIN
523:
524: IF (p_cafv_rec.sts_code = OKL_API.G_MISS_CHAR OR p_cafv_rec.sts_code IS NULL)
525: THEN

Line 542: 'FND_LOOKUP_VALUES');

538: 'sts_code',
539: g_child_table_token ,
540: 'OKL_CASH_FLOWS_V',
541: g_parent_table_token ,
542: 'FND_LOOKUP_VALUES');
543: l_return_status := OKC_API.G_RET_STS_ERROR;
544:
545: END IF;
546: END IF;

Line 621: FROM Fnd_Lookup_Values

617: l_dummy_var VARCHAR2(1) := '?' ;
618:
619: CURSOR okl_cafv_cft_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
620: SELECT 'x'
621: FROM Fnd_Lookup_Values
622: WHERE fnd_lookup_values.lookup_code = p_lookup_code
623: AND fnd_lookup_values.lookup_type = p_lookup_type ;
624:
625: BEGIN

Line 622: WHERE fnd_lookup_values.lookup_code = p_lookup_code

618:
619: CURSOR okl_cafv_cft_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
620: SELECT 'x'
621: FROM Fnd_Lookup_Values
622: WHERE fnd_lookup_values.lookup_code = p_lookup_code
623: AND fnd_lookup_values.lookup_type = p_lookup_type ;
624:
625: BEGIN
626:

Line 623: AND fnd_lookup_values.lookup_type = p_lookup_type ;

619: CURSOR okl_cafv_cft_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
620: SELECT 'x'
621: FROM Fnd_Lookup_Values
622: WHERE fnd_lookup_values.lookup_code = p_lookup_code
623: AND fnd_lookup_values.lookup_type = p_lookup_type ;
624:
625: BEGIN
626:
627: IF (p_cafv_rec.cft_code = OKL_API.G_MISS_CHAR OR p_cafv_rec.cft_code IS NULL)

Line 645: 'FND_LOOKUP_VALUES');

641: 'cft_code',
642: g_child_table_token ,
643: 'OKL_CASH_FLOWS_V',
644: g_parent_table_token ,
645: 'FND_LOOKUP_VALUES');
646: l_return_status := OKC_API.G_RET_STS_ERROR;
647:
648: END IF;
649: END IF;