DBA Data[Home] [Help]

APPS.OKL_IRH_PVT dependencies on FND_LOOKUPS

Line 662: l_residual_type FND_LOOKUPS.MEANING%TYPE;

658: FUNCTION check_existence (p_irhv_rec IN okl_irhv_rec) RETURN VARCHAR2 IS
659: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'check_existence';
660: l_residual_id NUMBER;
661: l_residual_exists BOOLEAN := false;
662: l_residual_type FND_LOOKUPS.MEANING%TYPE;
663: l_category_type FND_LOOKUPS.MEANING%TYPE;
664: l_source_type VARCHAR2(30);
665:
666: -- Cursor to get look_up meaning

Line 663: l_category_type FND_LOOKUPS.MEANING%TYPE;

659: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'check_existence';
660: l_residual_id NUMBER;
661: l_residual_exists BOOLEAN := false;
662: l_residual_type FND_LOOKUPS.MEANING%TYPE;
663: l_category_type FND_LOOKUPS.MEANING%TYPE;
664: l_source_type VARCHAR2(30);
665:
666: -- Cursor to get look_up meaning
667: CURSOR get_lookup_meaning(p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS

Line 671: FND_LOOKUPS FND

667: CURSOR get_lookup_meaning(p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
668: SELECT
669: FND.MEANING
670: FROM
671: FND_LOOKUPS FND
672: WHERE
673: FND.LOOKUP_TYPE = p_lookup_type
674: AND FND.LOOKUP_CODE = p_lookup_code;
675: