43: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
44:
45: CURSOR obj_name_csr(object_type IN VARCHAR2) IS
46: SELECT MEANING 47: FROM FND_LOOKUPS 48: WHERE LOOKUP_TYPE = 'OKL_FRONTEND_OBJECTS'
49: AND LOOKUP_CODE = object_type;
50:
51: --function to return the message from fnd message for the subject of the notifications