APPS.OKL_LEASEAPP_TEMPLATE_PVT dependencies on FND_LOOKUPS

Line 1059: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE

1055: -- Parameters :
1056: -- Version : 1.0
1057: -- History : 12-MAY-2005 SKGAUTAM created
1058: -- End of comments
1059: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
1060: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
1061: RETURN VARCHAR IS
1062: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%TYPE
1063: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS

Line 1060: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)

1056: -- Version : 1.0
1057: -- History : 12-MAY-2005 SKGAUTAM created
1058: -- End of comments
1059: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
1060: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
1061: RETURN VARCHAR IS
1062: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%TYPE
1063: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
1064: SELECT MEANING

Line 1062: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%TYPE

1058: -- End of comments
1059: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
1060: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
1061: RETURN VARCHAR IS
1062: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%TYPE
1063: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
1064: SELECT MEANING
1065: FROM FND_LOOKUPS FND
1066: WHERE FND.LOOKUP_TYPE = p_lookup_type

Line 1063: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS

1059: FUNCTION get_lookup_meaning( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
1060: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
1061: RETURN VARCHAR IS
1062: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%TYPE
1063: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
1064: SELECT MEANING
1065: FROM FND_LOOKUPS FND
1066: WHERE FND.LOOKUP_TYPE = p_lookup_type
1067: AND FND.LOOKUP_CODE = p_lookup_code;

Line 1065: FROM FND_LOOKUPS FND

1061: RETURN VARCHAR IS
1062: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%TYPE
1063: ,p_lookup_code fnd_lookups.lookup_code%TYPE) IS
1064: SELECT MEANING
1065: FROM FND_LOOKUPS FND
1066: WHERE FND.LOOKUP_TYPE = p_lookup_type
1067: AND FND.LOOKUP_CODE = p_lookup_code;
1068: l_return_value VARCHAR2(80) := NULL;
1069: BEGIN